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
13783 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

What is cursor status?

1193

How can we solve sql error: ora-00904: invalid identifier?

1253

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1121

does sql support programming? : Sql dba

1052

What is pl sql and why it is used for?

1114

Mention what is the plv (pl/vision) package offers?

1108

what is unique key constraint? : Sql dba

1044

In a distributed database system, can we execute two queries simultaneously?

1098

How do I count rows in sql query?

998

What is the difference between explicit and implicit cursors in oracle?

1070

How many sql statements are used?

1017

What is the sql query to display the current date?

1048

Can procedure in package be overloaded?

1089

What is a relationship and what are they?

1155

What is the use of function in sql?

1098