how to retrieve the top 3 salaries of the table using rownum
Answer Posted / swapnareddy
select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Explain ddl statements in pl/sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
Write a sql select query that only returns each name only once from a table?
What is data type in database?
What is the difference between the sql*loader and import utilities? : aql loader
What are two statement types in sql?
What is the full form of sql?
Can primary key be changed?
What is a temporal data type?
What is the use of nvl function?
How to select all records from the table?
What are the ddl commands?
What sql database should I use?
Can we commit inside a trigger?
what is user defined functions? : Sql dba