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 / mk

Answer Posted / mk

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are character functions in sql?

943

What are functions in sql?

962

Is full outer join same as cross join?

973

What mean sql?

1016

What type of join is sql join?

988

How do I partition in sql?

968

What is insert command in sql?

1135

What are all ddl commands?

1088

What is $$ in sql?

998

Explain two easy sql optimizations.

1019

What is error ora-12154: tns:could not resolve the connect identifier specified?

1084

What are sql commands?

1017

How do you modify a trigger?

930

How many functions are there in sql?

1042

Does view contain data?

1040