SELECT * FROM EMP E,DEPTS D WHERE E.DEPT_ID=D.DEPT

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 / selvaraj v , anna university

7 Answers
13974 Views
Geometric Software, IBM, I also Faced
E-Mail Answers

Answer Posted / selvaraj v , anna university

SELECT * FROM EMP E,DEPTS D WHERE E.DEPT_ID=D.DEPT_ID AND
E.SALARY BETWEEN 2000 AND 3000 ORDER BY EMP_NO;

Is This Answer Correct ?

14 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to include character strings in sql statements? : Sql dba

1142

Can we commit in trigger?

1029

What is the usage of nvl function?

1103

Is left join inner or outer by default?

1074

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1211

Which data type is a composite type?

1037

What is not equal in sql?

1197

How to combine two stored procedures in sql?

1326

What are operators available in sql?

1096

What does 0 mean in sql?

1020

Can there be 2 primary keys in a table?

1046

what is a view? : Sql dba

1136

Explain mutating table error.

1264

Does truncate release storage space?

1137

Can you upgrade sql express to full sql?

1144