how to retrieve the top 3 salaries of the table using rownum
Answer Posted / nitesh
select sal from emp e where 3>=(select count(distinct sal)
from emp where sal>e.sal) order by sal desc;
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How would you convert date into julian date format?
Which data dictionary views have the information on the triggers that are available in the database?
What does <> sql mean?
What is execute immediate?
Can we rename a column in the output of sql query?
How to set up sql*plus output format in oracle?
What is rownum and rowid?
Does oracle roll back the transaction on an error?
What is the command used to fetch first 5 characters of the string?
Is inner join faster than left join?
what are sequences
What is trigger price?
What is a table in a database?
What is union?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????