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
- 12569 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 is oracle sql called?
How is a process of pl/sql compiled?
How many types of keys are there in sql?
What is a join query?
What is the basic structure of an sql?
what are the differences between require and include, include_once and require_once? : Sql dba
Is primary key is clustered index?
What is sql engine in oracle?
What is difference between pls_integer and integer?
What is the difference between count 1 and count (*) in a sql query?
Explain aggregate functions are available there in sql?
explain advantages of myisam over innodb? : Sql dba
How do you declare a user-defined exception?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What does the argument [or replace] do?
