Apr 13, 2009

nth highest Salaray

Question: select nth highest Salaray...
Answer: select sal as salary from emp order by sal desc limit n-1,1;
Posted by

1 comment:

Sarvesh Tiwari said...

This is very very useful question, Each and every interview have this question.

July 1, 2011 at 10:22 PM

Post a Comment

Subscribe to: Post Comments (Atom)