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
Sql technical questions
What is sql scripting?
what is primary key? : Sql dba
How do you optimize a stored procedure in sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
How do I tune a sql query?
What is clause?
How do you break a loop in pl sql?
What is secondary key?
Why do we need sharding?
What is a unique key and primary key and foreign key?
Why we use pl sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Can we create index on primary key?
what are the differences between char and nchar? : Sql dba
