select * from(select ename,deptno,sal from emp order by sal desc) where row

select top 3 sal from each dept?

Question Posted / anil

17 Answers
27184 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / anil

select * from(select ename,deptno,sal from emp order by sal desc) where rownum<=3

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql trigger example?

1021

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1068

what is self-join? : Sql dba

1090

Explain commit, rollback and savepoint.

958

Can we call a function containing dml statements in a select query?

943

What is meant by <> in sql?

914

Why do we use cursors?

946

Why do we need databases?

1003

What is multiple partition?

942

what are properties of a transaction? : Sql dba

1054

What are few of the schema objects that are created using PL/SQL?

998

What is dynamic query?

935

how can you see all indexes defined for a table? : Sql dba

963

What are the types of records?

970

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4162