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 is difference between delete and truncate commands? : Sql dba

591

what is meant by nl2br()? : Sql dba

576

what is a composite primary key ? : Sql dba

591

How many developers work on postgresql?

578

What is the trigger in sql?

548

how to dump a table to a file with 'mysqldump'? : Sql dba

563

Can we insert data in view?

511

Mention what pl/sql package consists of?

549

describe mysql connection using mysql binary. : Sql dba

563

how can we know the number of days between two given dates using mysql? : Sql dba

558

Explain the significance of the & and && operators in pl sql.

579

What is data profiling in sql?

531

What is normalisation in sql?

559

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

650

Can we update views in sql?

543