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:
9 comments Page 1 of 1.
Shiva said:
2 years ago
@All.
Here is my code;
select ename
from emp
where deptno in (10,20) and sal>800; ---->here 'in' is acts as =
-----------------------------------------------------
select ename
from emp
where deptno not in (10,20) and sal>800; ---->here 'not in' is acts as !=
Here is my code;
select ename
from emp
where deptno in (10,20) and sal>800; ---->here 'in' is acts as =
-----------------------------------------------------
select ename
from emp
where deptno not in (10,20) and sal>800; ---->here 'not in' is acts as !=
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.
Saurabh said:
9 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?
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';
(2)
Aaru said:
1 decade ago
select empid from 'employee' where category NOT IN (manager);
Isn't the above correct?
Isn't the above correct?
Srinivas said:
1 decade ago
Can any one explain about 'NOT IN' command?
Kirti said:
1 decade ago
Please explain what is IN & OUT.
Avinash chikane said:
10 years ago
What is in & out clause?
Abhi said:
1 decade ago
Thanks Suresh.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers