List:General Discussion« Previous MessageNext 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 numberMark Goodge3 Dec
  • Re: Lowest non-zero numberPaul Halliday3 Dec
    • Re: Lowest non-zero numberMark Goodge3 Dec
      • Re: Lowest non-zero numberMySQL)3 Dec
  • Re: Lowest non-zero numberMySQL)3 Dec