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

How do I run pl sql in sql developer?

625

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1638

What are sql ddl commands?

545

Explian rowid, rownum? What are the psoducolumns we have?

566

What are schema-level triggers?

574

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

529

Is sql a oracle?

521

How do I create a sql script?

538

What is faster join or subquery?

508

What are the types of queries in sql?

516

How to call a javascript function from pl sql?

559

What does select * from mean in sql?

1984

What is parallel hint?

746

What is substitution variable?

577

What is sql catalog?

558