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
13784 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 the difference between having clause and where clause?

1067

What are sql commands?

1017

What is varray in pl sql?

1081

Can we create index on primary key?

977

Is pl sql useful?

997

what is a composite primary key ? : Sql dba

1057

What are different types of queries in sql?

1122

List different type of expressions with the example.

935

What is an alias command?

1071

What is numeric function sql?

1069

When to use inner join and left join?

963

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1349

explain the options of myisamchk to improve the performance of a table. : Sql dba

1022

how can we submit a form without a submit button? : Sql dba

996

Is inner join same as self join?

1122