You can also solve it by using sub-query SELECT DISTINCT NAME FROM EMP

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 / sravan

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

Please Help Members By Posting Answers For Below Questions

What is procedure function?

981

What is cost in sql execution plan?

897

How many commands are there in sql?

970

List the different type of joins?

996

how many values can the set function of mysql take? : Sql dba

932

Is sql free?

884

What is mutating error?

906

Can dml statements be used in pl/sql?

1018

What is the difference between clustered and non-clustered index in sql?

954

What is clause in sql?

1050

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1079

When should I use nosql database?

943

What are the parameter modes supported by pl/sql?

1015

Can sql function call stored procedure?

955

How can I change database name in sql?

1000