How to find second highest salary of an emp | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How to find second highest salary of an emp

4th Jul 2019, 3:48 AM
Jatin Agarwal
Jatin Agarwal - avatar
2 Answers
+ 1
Sort employers by salary and use the second record to find the value of its salary field.
4th Jul 2019, 4:24 AM
Sonic
Sonic - avatar
0
Can you give me query for the same?
12th Jul 2019, 6:13 PM
Jatin Agarwal
Jatin Agarwal - avatar