Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / chiru
select *
from (select row_number() over(partition by deptno order by sal desc) r,
b.*
from (select rownum num, a.* from emp a order by sal desc) b)
where r <= 3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
Explain the savepoint statement.
define sql update statement ? : Sql dba
how to show all tables with 'mysql'? : Sql dba
What is the advantage of nosql?
how many groups of data types? : Sql dba
What is index example?
What version is sql?
What found sql?
What are different clauses used in sql?
What are the various levels of constraints?
Can we rollback truncate?
What are pl/sql cursors?
how many sql dml commands are supported by 'mysql'? : Sql dba
Explain dml and ddl?
What are sql commands?
