SELECT E.ENAME FROM EMP E ,DEPT D WHERE E.DEPTNO=D.DEPTNO AND SAL BETWEEN

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 / om patel

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

Answer Posted / om patel

SELECT E.ENAME FROM EMP E ,DEPT D WHERE E.DEPTNO=D.DEPTNO
AND SAL BETWEEN 2000 AND 3000 AND D.DNAME='X';

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are functions in sql?

936

Mention what does the hierarchical profiler does?

1066

what is a foreign key ? : Sql dba

1065

what is self-join? : Sql dba

1127

how to analyze tables with 'mysqlcheck'? : Sql dba

996

what is a join? : Sql dba

1009

how to select first 5 records from a table? : Sql dba

963

how do you control the max size of a heap table? : Sql dba

960

Why we use joins in sql?

965

What is delimiter sql?

966

What is an index in sql with example?

959

how can you create an empty table from an existing table? : Sql dba

1135

What does bitemporal mean?

1048

Define a temp table?

1005

What is cursor and its types?

1048