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 |
Post New Answer View All Answers
Is there any restriction on the use of union in embedded sql?
How do I sort a table in sql?
what are all the common sql function? : Sql dba
What is record in pl sql?
What is inner join in sql?
What does the acronym acid stand for in database management?
What is the least restrictive isolation level? : Transact sql
Can we use commit inside a trigger?
Is pl sql still used?
what is the difference between primary key and unique key? : Sql dba
What are procedures used for?
What are the types of operators available in sql?
Is primary key is clustered index?
How do you clear the screen in sql?
How would you convert date into julian date format?
