SQL – Select second highest value for a column in a Table

Post Info: 214 views 0 Comments Post a comment

Here is the SQL to SELECT the second highest value from a TABLE:

SELECT max(value) FROM TABLE WHERE value NOT IN (SELECT max(value) FROM the TABLE);

Return to top

Leave a Reply

 

Are you finished?

Return to top