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
13497 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 are different types of keys in sql?

1067

Is left join faster than inner join?

1065

Explain architecture of sql server notification services?

990

What is dynamic query?

917

Why do we use triggers?

916

How do you go back in sql?

942

What is a design view?

887

How can you save or place your msg in a table?

955

What is the use of non clustered index?

930

Is pl sql better than sql?

982

Who developed sql?

965

How to use transactions efficiently : transact sql

993

How to return an array from java to pl/sql?

1063

How to fetch alternate records from a table?

1162

What is record in pl sql?

1011