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

What are the methods of filing?

878

Explain the difference between sql and mysql.

1003

What is the clause we need to add in function body to return variable?

968

What is the purpose of cursors in pl/sql?

1081

how to create a new table in mysql? : Sql dba

935

What is scalar data type in pl sql?

1020

Which join is like inner join?

978

What are field types?

942

What does select * from mean in sql?

3074

What is a trigger word?

964

Show the two pl/sql cursor exceptions.

1110

Explain some predefined exceptions.

993

Does truncate table reset auto increment?

941

Should I use mbr or gpt?

950

What is indexing oracle sql?

1026