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

How do I access sql anywhere database?

921

Explain the difference between sql and mysql.

1003

Can we use rowid as primary key?

944

Mention what plvcmt and plvrb does in pl/sql?

1062

How to start the command-line sql*plus?

1002

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

920

How can I speed up sql query?

907

What are the types of index in sql?

1016

What is memory optimized table?

986

What is acid property in a database?

974

How do you remove duplicates without using distinct in sql?

922

How do I audit the sql sent to the server?

958

Can we use update in sql function?

1010

Write a query to display the current date in sql?

969

How can you fetch first 5 characters of the string?

948