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 row_number () in sql?

989

How do I remove duplicates in two columns?

1078

What is string join?

981

Define a temp table?

1025

what is datawarehouse? : Sql dba

1026

How do I view tables in mysql?

987

Is left join inner or outer by default?

1026

Can we group by two columns in sql?

1001

Is postgresql a server?

1056

List the ways to get the count of records in a table?

902

Which sorts rows in sql?

1025

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

1106

How do I write a sql query in pgadmin 4?

993

What is a database trigger?

1073

How do you write an inner join query?

957