select * from test_sujith where rownum

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / sujith

Answer Posted / sujith

select * from test_sujith where rownum < 6 order by item3 desc

Is This Answer Correct ?

2 Yes

31 No

Please Help Members By Posting Answers For Below Questions

How do I run sql profiler?

1008

Which constraints we can use while creating database in sql?

1018

what is sp_pkeys? : Transact sql

1104

What is $$ in sql?

943

How do I create an index in word?

968

what is timestamp in mysql? : Sql dba

1003

Can two tables have same primary key?

917

what are the differences between char and varchar? : Sql dba

1004

What is an exception in pl/sql?

1009

What is procedure in pl sql?

980

What is the advantage of nosql?

996

what is rdbms? : Sql dba

962

What is a .db file?

928

How do I find duplicates in the same column?

1000

what is log shipping? : Sql dba

1059