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 to rename an existing table in mysql? : Sql dba

1064

What are crud methods?

1040

What are the two types of periodical indexes?

940

How do I find duplicates in a single column in sql?

1025

What is sql character function?

1091

Is it possible to update views?

963

What are different types of sql?

1196

What are the two types of exceptions.

1173

What is difference between table and view?

1065

Is subquery faster than join?

1019

What is a crud api?

956

how to select unique records from a table? : Sql dba

1117

what is datawarehouse? : Sql dba

1026

What is the best sql course?

989

What is sql prepared statement?

989