find the third highest salary?

Answer Posted / rohit kumar

select min(sal) from (select sal from emp order by sal
desc) where rownum <= 3

Is This Answer Correct ?    17 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql exception?

515


what are date and time data types in mysql? : Sql dba

497


define join and explain different type of joins? : Sql dba

544


How does rowid help in running a query faster?

965


How do I create a sql database?

518






what is the difference between truncate and delete statement? : Transact sql

542


Why does sql need a server?

560


What is difference between stored function and application function?

592


What is a dirty read sql?

476


What is the importance of sqlcode and sqlerrm?

845


Does group by remove duplicates?

545


What is indexes?

540


How are sql commands classified?

589


Why is nosql good?

591


How delete all data from table in sql?

568