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.
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
What is the need of merge statement?
What is sql not null constraint?
how can you see all indexes defined for a table? : Sql dba
What is an intersect?
what is a trigger? : Sql dba
discuss about myisam key cache. : Sql dba
What are the different sql languages?
What is primary key and foreign key?
Which is faster truncate or drop?
how can we submit a form without a submit button? : Sql dba
Write a unique difference between a function and a stored procedure.
explain the advantages and disadvantages of stored procedure? : Sql dba
how many values can the set function of mysql take? : Sql dba
Can we use the cursor's to create the collection in PL/SQL?
What is difference between group by and partition by?