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

Can we join more than 2 tables in sql?

1001

Is sql between inclusive?

1110

What is the difference between rename and alias?

1326

Why are cursors used?

1104

Enlist some predefined exceptions?

1037

How to rename a column in the output of sql query?

1064

Can you inner join the same table?

978

What is the difference between pl and sql?

1076

Can a procedure in a package be overloaded?

1029

Why use stored procedures?

1063

Is truncate ddl or dml?

976

What are crud methods?

1015

What does count (*) mean in sql?

1555

How many types of triggers exist in pl/sql?

1051

Is big data nosql?

926