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

what does the t-sql command ident_current does? : Transact sql

982

Can we rename a column in the output of sql query?

995

Is left join and outer join same?

1070

What is the difference between python and sql?

1006

What is the command used to fetch the first 5 characters of a string?

1209

What are sql objects?

1081

what is the difference between primary key and unique key? : Sql dba

1039

What is a delimiter in sas?

1058

what is index? : Sql dba

1006

How can we make an if statement within a select statement?

1014

Are stored procedures faster than queries?

948

How many types of tables are there?

952

What is %rowtype in pl sql?

991

What is substitution variable in pl sql?

1046

What do you mean by rowid?

980