Method 01: --------- Select Ename, MAX (Sal) From Emp Group by ROWNUM,

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

Question Posted / manoranjan sethy

Answer Posted / manoranjan sethy

Method 01:
---------
Select Ename, MAX (Sal) From Emp
Group by ROWNUM, Ename
Having Rownum <=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the main features of cursor?

1071

What are the uses of sysdate and user keywords?

1105

what are date and time data types in mysql? : Sql dba

977

What is the difference between the conventional and direct path loads? : aql loader

1405

Can we use ddl statements in stored procedure sql server?

1015

Can pl sql procedure have a return statement?

1033

what are all the different types of indexes? : Sql dba

1051

what is the difference between char_length and length? : Sql dba

1050

What is the syntax to add a record to a table?

1091

explain mysql aggregate functions. : Sql dba

996

What is the purpose of a sql?

978

How do I tune a sql query?

981

List out the acid properties and explain?

966

What is pls integer?

1049

What are the types of triggers in sql?

1091