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.
- 7 Answers
- 12118 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
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Is coalesce faster than isnull?
How do you determine the current isolation level? : Transact sql
Why we use stored procedure instead of query?
What are commit, rollback, and savepoint?
How many parts of a pl sql block are optional?
What is over () in sql?
what is a constraint? : Sql dba
what is row? : Sql dba
What does subquery mean in sql?
Can we use pl sql in sql server?
What is a rank in sql?
What is a constraint?
how to install mysql? : Sql dba
Which sql statement is used to return only different values?
