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

Why do we use triggers?

968

what is an alias command? : Sql dba

1116

what is the difference between delete and truncate commands? : Sql dba

1070

What is a system versioned table?

986

Why use stored procedures?

1094

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1000

What is a sql trace file?

1031

What are system versioned tables?

1028

What is sqlite format?

1200

How delete a row in sql?

996

What schema means?

889

Can we use ddl commands in pl sql?

1162

what is sp_pkeys? : Transact sql

1159

What is pragma in sql?

1082

How do I create a memory optimized filegroup?

963