how to retrieve the top 3 salaries of the table using rownum
Answer Posted / kalyan kumar
select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)
Is This Answer Correct ? | 19 Yes | 10 No |
Post New Answer View All Answers
What are the types of functions in sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Define implicit and explicit cursors.
What is your daily office routine?
Is primary key a clustered index?
Which are the different types of indexes in sql?
what is the different between now() and current_date()? : Sql dba
What is sequence in sql?
How does rowid help in running a query faster?
what are sequences
What is the difference between jpql and sql?
What is the usage of distinct keyword?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What are the different types of dbms?
What are the two parts of design view?