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 we update views in sql?

896

How to fetch alternate records from a table?

1156

what is innodb? : Sql dba

1029

How to return an array from java to pl/sql?

1060

What if we write return in procedure?

1331

Is mariadb a nosql database?

1004

What is pl/sql language case sensitive?

1058

Can a key be both primary and foreign?

943

What is raw datatype in sql?

976

Write a sql query to convert all character to uppercase after hypen.

1375

What are different joins used in sql?

1007

What is spool?

990

what is 'mysqlcheck'? : Sql dba

958

What is primary key secondary key alternate key candidate key?

978

How do I truncate a word?

986