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
- 11593 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
Is drop table faster than truncate?
Why primary key is required?
Can we update views in sql?
What is composite primary key in sql?
What is auto increment?
What are the different ddl commands in sql?
Can a primary key be a foreign key?
Differentiate between % rowtype and type record.
What is sql injection owasp?
What are the parts of a basic sql query?
Is trigger a stored procedure?
What are the types pl/sql code blocks?
What is trigger types of trigger?
Can a varchar be a primary key?
What is a schema? How is it useful in sql servers?
