SELECT E.ENAME FROM EMP E ,DEPT D WHERE E.DEPTNO=D.DEPTNO AND SAL BETWEEN

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.

Question Posted / om patel

7 Answers
13496 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

Please Help Members By Posting Answers For Below Questions

What is pls_integer in pl sql?

1035

What is raid? How does it help storage of databases?

1036

Can you do multiple joins in sql?

977

What is the starting oracle error number?

999

Explain exception handling in pl/sql?

991

Does db2 use sql?

891

Can we connect to postgresql using sql developer?

940

What is parallel hint?

1223

What are the types of subqueries?

1019

what are integrity rules?

969

What are analytical functions in sql?

972

How to get unique records from a table?

898

how to create a new table in mysql? : Sql dba

936

What is the difference between union and union all command?

1011

what are rollup and cube in t-sql? : Transact sql

1049