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 is indexing in sql and its types?

1080

What is cte?

983

What is set transaction?

1037

Can we call procedure in select statement?

1056

What are operators available in sql?

1048

Why do we use function in pl sql?

1065

What is structural independence and why is it important?

1031

How do I remove duplicates in two columns?

1067

What is dba in sql? : SQL DBA

1044

How do you bind variables in pl sql?

1097

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

1016

What is keys and its types?

1075

What packages(if any) has oracle provided for use by developers?

5811

How do I create an index in word?

1034

What is varchar data type in sql?

1085