Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 23)
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.
Answer: Option
No answer description is available. Let's discuss.
8 comments Page 1 of 1.

Saurabh said:   6 years ago
When three or more OR conditions are combined, it is easier to use the IN or NOT IN, Can you suggest any keyword "When three or more AND conditions are combined?

Avinash chikane said:   8 years ago
What is in & out clause?

Aaru said:   10 years ago
select empid from 'employee' where category NOT IN (manager);

Isn't the above correct?

Neil said:   1 decade ago
Select empid from 'employee' where empid NOT IN( select empid from 'employee' where category="manager" )

This will list all those empid [employees] who are not manager.

Srinivas said:   1 decade ago
Can any one explain about 'NOT IN' command?

Abhi said:   1 decade ago
Thanks Suresh.

SURESH said:   1 decade ago
select * from emp
where ename in('SMITH','ALLEN'); IS SAME AS
select * from emp
where ename='SMITH'

Kirti said:   1 decade ago
Please explain what is IN & OUT.

Post your comments here:

Your comments will be displayed after verification.