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

Can you do multiple joins in sql?

1120

Why trigger is used in sql?

1015

What is cursor in pl sql with examples?

1091

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

1193

Is sql harder than python?

1157

How to write pl sql program in mysql command prompt?

1165

What is an inconsistent dependency?

1087

What is rowid in sql?

1054

how would concatenate strings in mysql? : Sql dba

1139

what is sp_pkeys? : Transact sql

1203

What is offset and limit in sql?

1105

Is sql the best database?

1027

What is a column in a table?

1186

what happens if null values are involved in expressions? : Sql dba

1093

What is sql injection vulnerability?

1005