how to retrieve the top 3 salaries of the table using rownum
Answer Posted / vik
select empno, ename, sal from (select * from emp order by
sal desc) where rownum < 4
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what are the 'mysql' command line options? : Sql dba
Does truncate remove indexes?
Which software is used for pl sql programming?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is mutating error in pl sql?
What is memory optimized table?
What is cte?
What is sql and also describe types of sql statements?
Can a procedure in a package be overloaded?
How exception is different from error?
what is a field in a database ? : Sql dba
define data blocks ? : Sql dba
how to convert dates to character strings? : Sql dba
Why is nosql good?
How to create an array in pl/sql?