Answer Posted / akki reddy
SELECT *
(SELECT SAL, ROWNUM RN FROM EMP ORDER BY SAL DESC)
WHERE RN=100;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is fmtonly in sql?
How many types of functions are there in sql?
What is structural independence and why is it important?
What are system versioned tables?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is the purpose of the primary key?
How to use sql*plus built-in timers?
Sql technical questions
what does it mean to have quoted_identifier on? : Sql dba
What are pl/sql cursor exceptions?
Which is faster joins or subqueries?
what are local and global variables and their differences? : Sql dba
What is a temp table?
how do you control the max size of a heap table? : Sql dba
How can I change database name in sql?