how to check the 3rd max salary from an employee table?
Answer Posted / manish_patil
select sal from emp_sal where rownum = 3 order by sal desc
Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is the need of merge statement?
what is clause? : Sql dba
Can we join same table in sql?
Explain spool.
What is trigger explain with example?
How many scalar data types are supported in pl/sql?
What does (+) mean in sql joins?
What do you understand by pl/sql cursors?
What is the difference between clustered and non-clustered index in sql?
Are null values same as that of zero or a blank space?
Is delete faster than truncate?
What is difference between my sql and sql?
Is sql the best database?
Can we use ddl commands in pl sql?