From: Paul Halliday Date: December 3 2010 4:56pm Subject: Re: Lowest non-zero number List-Archive: http://lists.mysql.com/mysql/223725 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 On Fri, Dec 3, 2010 at 12:50 PM, 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? > SELECT number FROM table WHERE number > 0 ORDER BY number ASC LIMIT 1; ? -- Paul Halliday Ideation | Individualization | Learner | Achiever | Analytical http://www.pintumbler.org