Thread
:
How to find second highest value of a column in a table?
View Single Post
#
5
(
permalink
)
08-09-2006, 09:02 PM
Dhana Funda
Posts: n/a
MySQL
answer.
Re: How to find second highest value of a column in a table?
[sql]
SELECT Max(quantity) FROM Trade
WHERE quantity Not In (SELECT MAX(quantity) FROM Trade);
[/sql]
Dhana Funda
MySQL