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 odpowiedzi
+ 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

Często masz takie pytania?

Ucz się bardziej efektywnie, za darmo:

Zobacz wszystkie kursy
Popularne dzisiaj
Just a little advice
5 Votes
Hello I bought a 1 year subscription by mistake and I want to get refund, someone can help me to know how can I get a refund
0 Votes
Python Courses Order
0 Votes
beginner
0 Votes
How to install any pup
0 Votes
Float or integer
1 Votes
Is possible to install Python 3.9 or later for Windows 7 ?
1 Votes
sololearn is too harsh
2 Votes
How to convert the below value to string
0 Votes
I Have problem with JavaScript ES6 Map & Set
1 Votes