select salary from (select salary,rownum from salary_tab order by salary

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

Question Posted / saisravanthi

Answer Posted / saisravanthi

select salary from
(select salary,rownum from salary_tab
order by salary_tab desc)
where rownum < 4;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does bitemporal mean?

1113

What are the most important ddl statements in sql?

1186

What is the use of function in sql?

1149

What is nosql example?

1089

Is sql a scripting language?

1083

how is myisam table stored? : Sql dba

1097

How do sql databases work?

1045

How long does it take to learn pl sql?

1104

how do you know if your mysql server is alive? : Sql dba

1127

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

What is the difference between cluster and non-cluster index?

1157

How much does sql certification cost?

1134

What is cursor in pl sql with examples?

1089

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1050

What's the difference between inner join and left join?

1039