0

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

9th Aug 2016, 3:04 PM
Amit J
Amit J - avatar
2 Antworten
+ 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