[sql]
SELECT TOP 1 quantity FROM Trade
WHERE quantity < (SELECT MAX(quantity) FROM Trade)
ORDER by quantity DESC;
[/sql]

Is this query will work? If it works what should be the output?

regards,
venkat