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
Can a trigger call a stored procedure?
How many functions are there in sql?
What is sql architecture?
Define sql delete statement.
Is sql similar to python?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is the usage of sql functions?
What are sql commands?
What is the difference between left outer join and left join?
How do temporal tables work?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
what are the disadvantages of mysql? : Sql dba
How many types of sql are there?
How to convert comma separated string to array in pl/sql?
What are the events on which a database trigger can be based?
