how to retrieve the top 3 salaries of the table using rownum
Answer Posted / chandrasekar.ramasamy
select sal from( select rownum,e.* from empmaster e order
by sal desc) where rownum < 4
Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
Why use stored procedures?
Is drop table faster than truncate?
What is not equal in sql?
What is null in pl/sql?
What is bind variable in pl sql?
How can you save or place your msg in a table?
How do I view output in sql developer?
What is the need of a partition key?
What are literals in sql server?
what is 'mysqlcheck'? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
Why do we use procedures in sql?
Is record in pl sql?
Does a join table need a primary key?
What are conditional predicates?