Try to use HAVING instead of WHERE. I hope that will help.
Julio Faerman wrote: JF: Hi ... I am need the following query to work : JF: SELECT JF: min(my_colum) as MINIMAL_VALUE JF: WHERE JF: MINIMAL_VALUE > 10 JF: JF: The query is not EXACTLY as this one, but i think it is enough to get you JF: the idea of my problem... JF: JF: Thnx for any help ! JF: []~S JF: julio JF: JF: JF: --------------------------------------------------------------------- JF: Before posting, please check: JF: http://www.mysql.com/manual.php (the manual) JF: http://lists.mysql.com/ (the list archive) JF: JF: To request this thread, e-mail <[EMAIL PROTECTED]> JF: To unsubscribe, e-mail <[EMAIL PROTECTED]> JF: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JF: -- sherzodR <[EMAIL PROTECTED]> use CGI::Session; --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php