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
Please Help Members By Posting Answers For Below Questions
Why do we use partitions in sql?
What are sql procedures?
What is the most common sql injection tool?
What are the three pl sql block types?
What is scalar and vector?
How to start the command-line sql*plus?
When to use inner join and left join?
How does sql store data?
What is dml statement?
How to get unique records from a table?
describe transaction-safe table types in mysql : sql dba
How do I run a script in sql developer?
How many sql are there?
what is sub-query? : Transact sql
Can a foreign key be a duplicate?
