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 do we need to check in database testing?
How to combine two stored procedures in sql?
Show code of a cursor for loop.
What is execution plan in sql?
What is forward declaration in pl sql?
Why do we go for stored procedures?
what are numeric data types? : Sql dba
Is like operator in sql case sensitive?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Is it important to partition hard disk?
What is dense_rank in sql?
Is json a nosql?
What are the different types of database management systems?
Which data type is a composite type?
Why do we use joins?