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 start pl sql?

997

What is the use of function in sql?

1152

Explain the uses of database trigger.

1175

Explain about various levels of constraint.

1000

Why is sql better than hql?

1062

What is a temporal data type?

1114

does sql support programming? : Sql dba

1088

Why commit is not used in triggers?

1088

Which are the different case manipulation functions in sql?

1077

How to get help at the sql prompt?

1163

how many groups of data types? : Sql dba

1075

What are two statement types in sql?

1158

What are predefined functions in sql?

1107

What is the benefit of foreign key?

1068

What will you get by the cursor attribute sql%notfound?

1129