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
Can we insert in view in sql?
What does rownum mean in sql?
What is pivot query?
What is meaning of <> in sql?
what is column? : Sql dba
What do you mean by field in sql?
What happens when a trigger is associated to a view?
What are actual parameters and formal parameters?
What is normalization? How many normalization forms are there?
What are the constraints available in sql?
What are functions in sql?
how to convert character strings to dates? : Sql dba
Explain lock escalation? : Transact sql
How do I truncate a word?
Can we use insert statement in function?