MySQL Lists: mysql: Lowest non-zero number

List:	General Discussion	« Previous Message Next Message »
From:	Mark Goodge	Date:	December 3 2010 4:50pm
Subject:	Lowest non-zero number
View as plain text

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

Thread
• Lowest non-zero number	Mark Goodge	3 Dec
• Re: Lowest non-zero number	Paul Halliday	3 Dec
• Re: Lowest non-zero number	Mark Goodge	3 Dec
• Re: Lowest non-zero number	MySQL)	3 Dec
• Re: Lowest non-zero number	MySQL)	3 Dec