how to find the second highest salary in a given table????
Answer Posted / mahesh
SELECT *
FROM (SELECT ROWNUM sl, salary
FROM (SELECT DISTINCT salary
FROM employees
ORDER BY salary))
WHERE sl = n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sharded cluster?
Explain coalesce function?
How to store pictures on to the database?
How to define an external table with a text file?
How to calculate date and time differences in oracle?
Explain the different normalization forms?
What do you mean by redo log file mirroring?
what are actual and formal parameters?
What is ordinary table in oracle?
What is object data modeling?
How to resolve name conflicts between variables and columns?
What are the differences between lov and list item?
Where is the export dump file located?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the relation of a user account and a schema?