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

what is cursor. write example of it. What are the attributes of cursor.

1404

What are aggregate functions in sql?

1172

Do prepared statements prevent sql injection?

957

How to call a javascript function from pl sql?

1150

What are different types of triggers?

1119

What are the advantages of indexing?

998

what are the disadvantages of mysql? : Sql dba

1153

Can we join two tables without common column?

1022

what are the different functions in sorting an array? : Sql dba

1032

what is data integrity? : Sql dba

1047

what is the difference between clustered and non clustered index in sql? : Sql dba

1135

Does inner join return duplicate rows?

998

how to concatenate two character strings? : Sql dba

1113

how to dump a table to a file with 'mysqldump'? : Sql dba

1045

Where is all the data on the internet stored?

1027