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


Please Help Members By Posting Answers For Below Questions

Difference between global and parameter variables?

1453


What does t sql mean?

532


Does sql backup shrink transaction log?

551


What is sql*loader?

570


Is microsoft sql free?

596






What is on delete restrict?

534


how to escape special characters in sql statements? : Sql dba

508


What is character functions?

554


Why is sql*loader direct path so fast?

595


What does select count (*) mean in sql?

544


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2567


What is sql engine in oracle?

519


What is oracle pl sql developer?

530


what is foreign key? : Sql dba

585


How do I remove sql developer from windows 10?

508