select* from(select ename,deptno,sal,row_number() over(partiton by deptno

select top 3 sal from each dept?

Question Posted / nag.vamshi

Answer Posted / nag.vamshi

select* from(select ename,deptno,sal,row_number()
over(partiton by deptno order by sal)num from emp)
where num<=3
order by deptno;

Is This Answer Correct ?

24 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Will truncate release space?

989

how to get a list of columns in an existing table? : Sql dba

1008

What will you get by the cursor attribute sql%found?

1009

What is field delimiter?

1111

How do I run a pl sql procedure in sql developer?

1021

What are literals in sql server?

1257

What is sql integrity?

1241

what is a constraint? : Sql dba

1231

What is mdb stand for?

1058

Is natural join same as inner join?

984

What operating systems are supported by oracle sql developer?

1012

What is the purpose of my sql?

1010

Does oracle roll back the transaction on an error?

1067

What is auto increment?

1044

What is consistency?

1187