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
Show how functions and procedures are called in a pl/sql block.
Explain select statements in sql?
how would you enter characters as hex numbers? : Sql dba
What is the cause of mutating table error and how can we solve it?
What are the query optimization techniques?
what is acid property in database? : Sql dba
What is the difference between local and global temporary table?
How to Execute a Package in PL/SQL.?
Is sql database free?
How to call shell script from pl sql procedure?
How do I partition in sql?
Why are sql stored procedures used?
Does sql view stored data?
What is the difference between left join and right join?
describe mysql connection using mysql binary. : Sql dba