with Q as (select *,dense_rank() over(partition by dept order by sal) as

select top 3 sal from each dept?

Question Posted / keshav

Answer Posted / keshav

with Q as (select *,dense_rank() over(partition by dept
order by sal) as dr from dept
select * from Q
where dr=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

State some properties of relational databases?

592

What is error ora-01000: maximum open cursors exceeded

609

is it possible to pass an object or table to a procedure as an argument?

585

What is the difference between pl and sql?

551

What is pl/sql table? Why is it used?

574

How to sort the rows in sql.

615

what is top in tsql? : Transact sql

553

explain mysql aggregate functions. : Sql dba

556

how to analyze tables with 'mysqlcheck'? : Sql dba

553

explain advantages of innodb over myisam. : Sql dba

656

What are the subsets of sql?

562

what is text? : Sql dba

575

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

505

What is data type in sql?

565

How can I tell if sql is running?

600