SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC )

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

Question Posted / yogesh sharma

Answer Posted / yogesh sharma

SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6;

Is This Answer Correct ?

77 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What is null in pl/sql?

1078

how to include character strings in sql statements? : Sql dba

1081

What is the current version of sql?

1030

What found sql?

948

How much does sql certification cost?

1096

What are all the common sql functions?

1039

What is difference between nchar and nvarchar?

1037

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

977

Write the command to remove all players named sachin from the players table.

1188

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1066

tell me about various levels of constraint. : Sql dba

1041

Enlist the characteristics of pl/sql?

1810

Explain the savepoint statement.

1103

How do you identify a primary key?

1067

What are the features of pl sql?

1074