Lowest non-zero number

[Mark Goodge]

Given a table containing a range of INT values, is there any easy way to 
select from it the lowest non-zero number?

Obviously, MAX(column) will return the highest, but MIN(column) will 
return 0 if any row contains a 0, which isn't what I want.

Any clues?

Mark
--
http://mark.goodge.co.uk

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org