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
what are the different index configurations a table can have? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
How to execute a stored procedure?
What is an inner join sql?
How do I save a stored procedure?
What is trigger and types?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is sqlca in db2?
What is cross join example?
what does the t-sql command ident_current does? : Transact sql
What is compute?
How do you select unique values in sql?
How do I make my sql query run faster?
What is sql integrity?
What are pl/sql cursors?
