how to retrieve the top 3 salaries of the table using rownum
Answer Posted / dhiman sarkar
select empname,sal from (select empname,sal from dh1 order
by sal desc)
where rownum < =4
order by sal desc
| Is This Answer Correct ? | 17 Yes | 7 No |
Post New Answer View All Answers
How do I restart sql?
Does truncate table reset auto increment?
Who developed sql?
How show all rows in sql?
How to sort the rows in sql.
what are the t string functions available in tsql? : Transact sql
Explain table and field in sql?
Is sql a case sensitive language?
what is innodb? : Sql dba
What is procedure and function in sql?
Define implicit and explicit cursors.
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Is sql easier than java?
Mention what is the use of function "module procedure" in pl/sql?