select empid,salary from (select empid,salary from emp ord

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

Question Posted / amit bharane

Answer Posted / amit bharane

select empid,salary
from (select empid,salary
from emp
order by sal desc)
where rownum <=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is sql*plus?

1196

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

1160

Explain how exception handling is done in advance pl/sql?

1045

What is Difference Between Unique and Primary Key Constraints?

1153

What is self-join and what is the requirement of self-join?

1191

What are schema-level triggers?

1151

Can instead of triggers be used to fire once for each statement on a view?

1006

What is sqlcommand?

1071

how would concatenate strings in mysql? : Sql dba

1139

What is trigger and types?

1069

What are the usages of sql?

1099

How do I partition in sql?

1021

What does rownum mean in sql?

1089

Determine if oracle date is on a weekend?

1088

Is sql a dbms?

1060