Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gautam
select * from (
SELECT ROWNUM as RANK, ename, sal
FROM (SELECT ename,sal FROM emp ORDER BY sal DESC)
WHERE ROWNUM <= 3)
where rank=3
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How many indexes can be created on a table in sql?
Does google use sql?
Is primary key a clustered index?
What is dml statement?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Which data type is a composite type?
How to run pl/sql statements in sql*plus?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is aggregate function in sql?
What is sql partition?
Which table is left in join?
What is oracle and pl sql?
Why do we need sharding?
What is query syntax?
What is loop in pl sql?
