how to find the second highest salary in a given table????
Answer Posted / manikandan. s
This is the nth max
SELECT salary
FROM (SELECT ROWNUM sl, salary
FROM (SELECT salary
FROM employees
GROUP BY salary
ORDER BY salary))
WHERE sl = n
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain rename?
List out the types of joins.
Can you assign multiple query result rows to a variable?
What are the attributes of the cursor?
What is a schema in oracle?
What is difference between truncate and delete?
What are the data types in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is difference between cartesian join and cross join?
How to filter out duplications in the returning rows using oracle?
How to use "in out" parameter properly?
How to define an oracle cursor variable?
How to bring a tablespace offline?
What do you mean by a tablespace?