SQL query to find the second largest value

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