suppose I have two table one Emp and other is dpt.
Emp table has a field ,dept id,name ,sal and dpt table has a
field dept id,dept name.
Now I want to find out the emplyee list whose sal is between
2000-3000 from dept x.
- 7 Answers
- 12610 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
Answer Posted / sravan
You can also solve it by using sub-query
SELECT DISTINCT NAME FROM EMP E
WHERE SAL>2000 AND SAL<3000
AND E.DEPTID IN (SELECT D.DEPTID FROM DPT D
WHERE DEPTNAME='X');
thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does group by remove duplicates?
How do I install sql?
What is the maximum rows in csv?
How to add, remove, modify users using sql?
Are dml statements autocommit?
Is record in oracle pl sql?
What are the advantages of sql?
Is ms sql traffic encrypted?
What is mutating error in pl sql?
What is oracle pl sql developer?
How many sql core licenses do I need?
What is snowflake sql?
How to run sql statements with oracle sql developer?
What is the reports view in oracle sql developer?
What is an index in sql with example?
