SQL query to find the second largest value

by Sowndarya 2014-03-01 15:16:58



The following query will be used to retrieve the second highest mark among table of marks.


Name mark

aa 100
bb 98
cc 95

<font color=#AA001A>SELECT MAX(mark) FROM students WHERE mark < (SELECT MAX(mark) FROM students)</font>

<font color=#AA001A>Result:</font>
mark
98
600
like
0
dislike
0
mail
flag

You must LOGIN to add comments