Discussion :: Introduction to SQL - General Questions (Q.No.23)
| 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' OR ENAME='ALLEN'; |
|
| 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.