how to retrieve the top 3 salaries of the table using rownum

Answer Posted / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain ddl statements in pl/sql?

578


explain the difference between myisam static and myisam dynamic. : Sql dba

519


Write a sql select query that only returns each name only once from a table?

572


What is data type in database?

548


What is the difference between the sql*loader and import utilities? : aql loader

600






What are two statement types in sql?

540


What is the full form of sql?

534


Can primary key be changed?

529


What is a temporal data type?

599


What is the use of nvl function?

619


How to select all records from the table?

609


What are the ddl commands?

537


What sql database should I use?

553


Can we commit inside a trigger?

549


what is user defined functions? : Sql dba

551