|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Lowest non-zero number
From: Mark Goodge (mark
good-stuff.co.uk)
Date: Fri Dec 03 2010 - 10:50:11 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]