what will be the query to find 2nd largest element from column? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

what will be the query to find 2nd largest element from column?

sql
9th Aug 2016, 3:04 PM
Amit J
Amit J - avatar
2 Answers
+ 1
SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee )
15th Aug 2016, 10:51 AM
Ashutosh Singh
0
Yes.. Thanks alot
15th Aug 2016, 10:55 AM
Amit J
Amit J - avatar

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
[SOLVED] How to create animation in Python?
2 Votes
[Clearified] 0 === -0 and 0 == -0
3 Votes
How to stop pop up menu from qt table horizontal header
0 Votes
Why printf("%p", x); shows the same address as printf("%p", &x); ?
1 Votes
What next?
0 Votes
Popsicle program
1 Votes
please help me emotionally
1 Votes
Why are not all the codes showing?
0 Votes
R programming
2 Votes
Why 'null >= 0' is TRUE?
2 Votes