Find out the 3rd highest salary?
Answer Posted / shaiju nair
select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)
| Is This Answer Correct ? | 13 Yes | 25 No |
Post New Answer View All Answers
Are stored procedures faster than queries?
explain commit and rollback in mysql : sql dba
Write an sql query to select all records from the table?
What is materialized view in sql?
what is text? : Sql dba
Does sql profiler affect performance?
What is substitution variable?
Which is faster view or stored procedure?
Why procedure is used in sql?
what is difference between delete and truncate commands? : Sql dba
define sql delete statement ? : Sql dba
Does oracle use sql?
What does (+) mean in sql joins?
Is microsoft sql free?
What is sp_helptext?