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
- 11567 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
Why stored procedure is better than query?
How does rowid help in running a query faster?
Explain the purpose of %type and %rowtype data types with the example?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is a table partition?
Define a temp table?
What does a pl/sql package consist of?
What pl/sql package consists of?
What are the three forms of normalization?
What does := mean in pl sql?
What is record type in pl sql?
What is duration in sql profiler trace?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
what are local and global variables and their differences? : Sql dba
What is trigger and how to use it in sql?
