how to retrieve the top 2 salaried persons from a database?
Answer Posted / arun
select salary from(select salary from(select distinct salary from employees order by salary desc) where rownum<=2 order by salary) where rownum=1;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between global and parameter variables?
What does t sql mean?
Does sql backup shrink transaction log?
What is sql*loader?
Is microsoft sql free?
What is on delete restrict?
how to escape special characters in sql statements? : Sql dba
What is character functions?
Why is sql*loader direct path so fast?
What does select count (*) mean in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is sql engine in oracle?
What is oracle pl sql developer?
what is foreign key? : Sql dba
How do I remove sql developer from windows 10?