On 12/3/2010 11:50, Mark Goodge wrote:
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
SELECT MIN(column) FROM table WHERE column>0 ?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org