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
14029 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 the current version of sql?

1087

what is sql server agent? : Sql dba

1167

Does group by remove duplicates?

1106

how to start mysql server? : Sql dba

1254

what is dbms? : Sql dba

1052

What is the current version of postgresql?

1150

What is the best sql course?

1036

What is your daily office routine?

2333

how many tables will create when we create table, what are they? : Sql dba

1132

what is schema? : Sql dba

1127

Is primary key always clustered index?

1085

Is primary key clustered index?

1006

How do I remove duplicates in two columns?

1170

define sql insert statement ? : Sql dba

1088

Can delete statement be rollbacked?

1046