Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / sujith
select * from test_sujith where rownum < 6 order by item3 desc
| Is This Answer Correct ? | 2 Yes | 31 No |
Post New Answer View All Answers
How do I run sql profiler?
Which constraints we can use while creating database in sql?
what is sp_pkeys? : Transact sql
What is $$ in sql?
How do I create an index in word?
what is timestamp in mysql? : Sql dba
Can two tables have same primary key?
what are the differences between char and varchar? : Sql dba
What is an exception in pl/sql?
What is procedure in pl sql?
What is the advantage of nosql?
what is rdbms? : Sql dba
What is a .db file?
How do I find duplicates in the same column?
what is log shipping? : Sql dba