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 are the datatypes available in pl/sql ?
Explain what is a field in a database and record in a database?
What is indexing oracle sql?
what is the difference between where clause and having clause? : Sql dba
what is an alias command? : Sql dba
What is t sql used for?
what are ddl statements in mysql? : Sql dba
Is primary key a clustered index?
Does a user_objects view have an entry for a trigger?
What is exception? What are the types of exceptions?
What is program debugging?
Enlist the advantages of sql.
Does mysql support pl sql?
What is dense_rank in sql?
Is it possible to update views?