Use subquery to get 2nd highest value in SQL

• Use ORDER BY clause to sort the values in descending order

• Use LIMIT 1 OFFSET 1 to skip the first highest value

• Alternatively, use a subquery to select the ma...read more