Answer Posted / pradeep
select * from emp where sal in(select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3);
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What are tables and fields?
What does select * from mean in sql?
What are triggers in sql?
Explain the working of foreign key?
What is dml statement?
Is sqlite thread safe?
define join and explain different type of joins? : Sql dba
What is flag in sql?
What is a delimiter in sas?
how to include comments in sql statements? : Sql dba
What are the types of join and explain each?
What are pl sql procedures?
What is the reports view in oracle sql developer?
What is the use of triggers?
What is cte sql?
