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

24 Answers
52288 Views
Cap Gemini, iNautix, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql developer case sensitive?

1048

How much does a sql dba make? : SQL DBA

988

What is the usage of nvl function?

1102

what is online transaction processing (oltp)? : Sql dba

1040

What is multiple partition?

1019

What is application trigger?

1056

Can you do multiple joins in sql?

1120

How do I debug a stored procedure?

1171

How do I count rows in sql query?

1040

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4060

What is pl sql variable?

1036

Why use triggers in sql?

1011

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1134

What are the two types of periodical indexes?

987

what is collation? : Sql dba

1205