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

Is primary key always clustered index?

1087

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

1136

how to start mysql server? : Sql dba

1258

what are aggregate and scalar functions? : Sql dba

1122

what are all the common sql function? : Sql dba

1121

define sql insert statement ? : Sql dba

1092

Is inner join faster than left join?

1271

what is bcp? When does it used? : Sql dba

1051

What is the current version of sql?

1091

If a cursor is open, how can we find in a pl/sql block?

1233

What is the best sql course?

1041

how to escape special characters in sql statements? : Sql dba

1108

Do we need to rebuild index after truncate?

1126

what is collation? : Sql dba

1222

what is sql server agent? : Sql dba

1171