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
13681 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 a field in a database ? : Sql dba

1043

how to use myisamchk to check or repair myisam tables? : Sql dba

957

Write a sql query to convert all character to uppercase after hypen.

1416

What is sqlservr exe?

965

Advantages and disadvantages of stored procedure?

1103

What is sql trigger example?

1032

What are sql functions? Describe the different types of sql functions?

1122

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2484

What is mutating sql table?

1088

Mention what is the use of function "module procedure" in pl/sql?

1038

What is a sql*loader control file?

1232

What is rownum in sql?

1008

What is basic structure of pl sql?

1049

Can we use delete in merge statement?

1030

what is heap table? : Sql dba

1091