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
- 11623 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
how to analyze tables with 'mysqlcheck'? : Sql dba
Is sql considered coding?
Is sql a scripting language?
What is indexing oracle sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is spool?
difference between anonymous blocks and sub-programs.
how do you login to mysql using unix shell? : Sql dba
How many types of privileges are available in sql?
How do you update f as m and m as f from the below table testtable?
How to select unique records from a table?
What is the primary key?
Why do we use sql constraints?
How to call shell script from pl sql procedure?
What is procedure and function?
