select * (select sal from emp order by 1 desc) where rownum

select top 3 sal from each dept?

Question Posted / sen

Answer Posted / sen

select *
(select sal from emp
order by 1 desc)
where rownum < 4

Is This Answer Correct ?

1 Yes

13 No

Please Help Members By Posting Answers For Below Questions

what is bcp? When is it used?

1070

when is the use of update_statistics command? : Sql dba

1003

What are character functions in sql?

908

What are sql functions? Describe in brief different types of sql functions?

1045

Can we update views in sql?

913

Is sql a microsoft product?

916

How do you create a db file?

974

Write a query to find the names of users that begin with "um" in sql?

946

how to select unique records from a table? : Sql dba

1074

What are the sql aggregate functions?

1080

What are the different ways to optimize a sql query?

910

What do you understand by pl/sql records?

991

What is an exception in pl/sql?

1027

What is indexes?

1027

what is a trigger in mysql? Define different types of trigger. : Sql dba

1033