Re: Fwd: A column of the SELECT-part of a query returns allways NULL in some cases.

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Victoria Reznichenko writes: Hi! Sinisa, i tested the following example on 4.0.1 and got the same result. If I don't use ORDER BY in the SELECT statement all worked fine: cut mysql SELECT u.gender AS gender,

Re: Fwd: A column of the SELECT-part of a query returns allways NULL in some cases.

Victoria Reznichenko writes: Hi! Sinisa, i tested the following example on 4.0.1 and got the same result. If I don't use ORDER BY in the SELECT statement all worked fine: mysql SELECT u.gender AS gender, count(DISTINCT u.id) AS dist_count, (count(DISTINCT u.id)/5*100) AS percentage from