how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 34050 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / chiru
select sal from (select distinct sal from emp order
by sal desc)
where rownum<4 ;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between where clause and having clause? : Sql dba
what are the security recommendations while using mysql? : Sql dba
Can we use having without group by in sql?
What is union, minus and interact commands?
How many sql commands are there?
What are basic techniques of indexing?
What are the parts of a basic sql query?
How can you select unique records from a table?
What are analytic functions in sql?
What is t sql in sql server?
What are the steps for performance tuning.
What are user defined functions?
Is truncate ddl or dml?
What are procedures used for?
How global cursor can be declare with dynamic trigger ?
