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
13982 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 is a call statement? Explain with an example.

1072

What are the benefits of pl/sql packages?

1166

How many tables can a sql database have?

1031

what is dbms? : Sql dba

1040

What are the types of queries in sql?

1134

Why use truncate instead of delete?

1074

How do you change a value in sql?

1070

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1070

What is a unique constraint?

1128

Can you upgrade sql express to full sql?

1146

What is procedure explain with program?

1069

How does postgresql compare to oracle/db2/ms sql server/informix?

1094

How do I save a stored procedure?

1073

What are secondary keys?

1034

What is a temporal data type?

1114