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
- 11647 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
Answer Posted / om patel
SELECT E.ENAME FROM EMP E ,DEPT D WHERE E.DEPTNO=D.DEPTNO
AND SAL BETWEEN 2000 AND 3000 AND D.DNAME='X';
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what are the advantages of using stored procedures? : Sql dba
when is the use of update_statistics command? : Sql dba
What is the difference between delete and truncate commands?
How do I copy a table in sql?
What are the advantages of indexing?
What is difference between joins and union?
what is a field in a database ? : Sql dba
What is indexes?
What is the advantage of index in sql?
How do we use distinct statement? What is its use?
What does the hierarchical profiler does?
What are stuff and replace function?
Is sql similar to python?
Explain 3 basic parts of a trigger.
How much ram can sql express use?
