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

select top 3 sal from each dept?

Question Posted / anil

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

Please Help Members By Posting Answers For Below Questions

How do I truncate a word?

1100

what are the advantages of mysql in comparison to oracle? : Sql dba

1010

What is a full join sql?

1063

explain advantages of myisam over innodb? : Sql dba

1073

What is multiple columns?

1077

Can we call procedure in select statement?

1067

Enlist the data types that can be used in pl/sql?

1077

what is the difference between myisam static and myisam dynamic? : Sql dba

1074

How to revise and re-run the last sql command?

1172

What is rowtype?

1027

Can we write dml inside a function in sql server?

964

what is user defined functions? : Sql dba

1039

what is a relationship and what are they? : Sql dba

1110

What is a temp table?

1032

What are database links used for?

1052