Answer Posted / imran ansari
find n th highest salary replace n with 1,2,3....to find second,third,fourth........sal
SELECT sal from emp order by sal desc limit 2,1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How would you pass hints to the sql processor?
explain about mysql and its features. : Sql dba
What is varchar example?
Do stored procedures prevent sql injection?
What are the different types of tables in sql?
Could you please provide oca (oracle 10g) dumps for my certification ?
Which join is default?
how to write date and time literals? : Sql dba
What are the features of pl sql?
What is form and report?
How do I get sql certification?
How do I find duplicates in the same column?
What is cross join example?
What is difference between inner join and self join?
Is drop table faster than truncate?