how to retrieve the top 3 salaries of the table using rownum
Answer Posted / rameshwar gupta
select ename ,sal from (select ename,sal from emp order
by sal desc)
where rownum<4
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What are tables and fields in the database?
Why do we use subquery?
Which is faster view or stored procedure?
Are left and right joins the same?
What are character functions?
what is 'mysqld'? : Sql dba
Where is sql database stored?
What are the different types of sql commands?
What is coalesce in sql?
explain advantages of innodb over myisam. : Sql dba
What is snowflake sql?
How can you select unique records from a table?
What is update query?
what is error ora-03113: end-of-file on communication channel?
What is the difference between local variables and global variables?