Database - Introduction to SQL - Discussion

Discussion :: 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):

[A]. LIKE only.
[B]. IN only.
[C]. NOT IN only.
[D]. Both IN and NOT IN.

Answer: Option D


No answer description available for this question.

Kirti said: (Aug 8, 2011)  
Please explain what is IN & OUT.

Suresh said: (Aug 28, 2011)  
select * from emp
where ename in('SMITH','ALLEN'); IS SAME AS
select * from emp
where ename='SMITH'

Abhi said: (Oct 22, 2011)  
Thanks Suresh.

Srinivas said: (Nov 6, 2011)  
Can any one explain about 'NOT IN' command?

Neil said: (Nov 7, 2012)  
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.

Aaru said: (Aug 16, 2013)  
select empid from 'employee' where category NOT IN (manager);

Isn't the above correct?

Avinash Chikane said: (Sep 7, 2015)  
What is in & out clause?

Saurabh said: (Nov 21, 2016)  
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?

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.