Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 23)
23.
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Discussion:
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?
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.
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'
OR
ENAME='ALLEN';
where ename in('SMITH','ALLEN'); IS SAME AS
select * from emp
where ename='SMITH'
OR
ENAME='ALLEN';
Kirti said:
1 decade ago
Please explain what is IN & OUT.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers