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
How many time I can use sololearn trial mode?
2 Votes
ĐžŃˆĐžĐ±ĐșĐ° ĐČ ĐżŃ€ĐžĐ»ĐŸĐ¶Đ”ĐœĐžĐž Sololearn
1 Votes
Is anyone else experiencing this Sololearn issue?
0 Votes
NEO V2.0
1 Votes
Did sololearn helped you to get easier a job?
1 Votes
Sololearn course
1 Votes
solo learn program issue - iPhone?
1 Votes
Is it possible to write Rust code that is as compact and expressive as Python?
0 Votes
Bug sur le deuxiĂšme cours de python
1 Votes
I am learning javascript intrmdt but when I play a code challenge. The app is givin me comlecated questions with less time.why?
0 Votes