Variable1 value exists in variable2 script

Question

I have a table with sample1 and sample2 Columns. Some of the sample2 values exist in sample 1. Now I want to extract a table where sample2 value is NOT available in sample1. Please see the tables below for clarification. Thanks.

It looks like your sample data is inconsistent with your description. E & I are in your sample 1 and sample 2 but still show on the output table — urdearboy
– urdearboy, Commented Feb 14, 2020 at 6:39

Yogesh Sharma · Accepted Answer · 2020-02-14 08:01:20Z

1

You can use NOT EXISTS :

SELECT t.*
FROM table t
WHERE NOT EXISTS (SELECT 1 FROM table t1 WHERE t1.sample1 = t.sample2);

answered Feb 14, 2020 at 8:01

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gordon Linoff Over a year ago

@mumid . . . NOT EXISTS is better with a subquery because it handles NULL values intuitively.

urdearboy · Accepted Answer · 2020-02-14 06:46:35Z

0

You basically said the answer in you question. Make sure Sample2 is NOT IN Sample1

SELECT *
FROM Table
WHERE Sample2 NOT IN (SELECT Sample1 From Table)

edited Feb 14, 2020 at 6:46

answered Feb 14, 2020 at 6:41

urdearboy

14.6k6 gold badges35 silver badges64 bronze badges

2 Comments

VBoka Over a year ago

You are welcome. You have been faster than me and here is a oracle fiddle if you want to attach it: dbfiddle.uk/… cheers

urdearboy Over a year ago

Trying to practice. Answering questions is how I learned my first language so moving onto SQL. I don't know how to use fiddle but will look at what you shared! Super useful

Collectives™ on Stack Overflow

Variable1 value exists in variable2 script

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related