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
- 11572 Views
- Geometric Software, IBM, I also Faced
- E-Mail Answers
Answer Posted / manasa
SELECT e.name,d.dept from employee e INNERJOIN dept d ON e.deptid=d.deptid WHERE e.salary between 2000 AND 3000
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Does truncate release storage space?
How can a pl sql block be executed?
Give the order of sql select?
What is difference sql and mysql?
How do I find duplicates in a single column in sql?
What is prepared statement in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
Does oracle use sql?
What are the packages in pl sql?
How do I remove sql developer from windows 10?
What do you mean by stored procedures?
Are stored procedures compiled?
What are different joins used in sql?
What is a function in oracle pl sql?
Can a foreign key have a different name?
