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

Answer Posted / vivek dubey

select salary_column from salary_table
where rownum<4
order by salary_column desc

Is This Answer Correct ?    24 Yes 42 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is sql important?

763


What is a delimiter in sas?

733


Can we debug stored procedure?

720


How do I restart sql?

723


How can use stored procedures in sql?

773






how mysql optimizes distinct? : Sql dba

730


What is the purpose of the partition table?

754


What are the advantages of pl sql over sql?

733


How do I edit a stored procedure?

724


What are the two different parts of the pl/sql packages?

791


Can we rollback truncate?

721


What is procedure explain with example?

704


what is the difference between char and varchar data types? : Sql dba

741


Can we update views in sql?

686


Which are the different character-manipulation functions in sql?

719