Angel Behar wrote:
>
> Hi !!!
>
> I'm running 3.23.28-gamma under windows NT, but I have the following
> problem.
> I need to query some data and gruop by some field (codigo in this case) so I
> run the following query :
>
> SELECT codigo from ropa where cve_depto='3' AND cve_clase='06' AND activo =
> 'A' AND p_credito <> 0 GROUP BY codigo;
>
> +--------+
> | codigo |
> +--------+
> | 319066 |
> +--------+
> 1 row in set (0.43 sec)
>
> the results are as I expected BUT I need to GROUP BY RAND() too and LIMIT to
> 10 rows :
>
> SELECT codigo from ropa where cve_depto='3' AND cve_clase='06' AND activo =
> 'A' AND p_credito <> 0 GROUP BY codigo, RAND() LIMIT 10;
>
> +--------+
> | codigo |
> +--------+
> | 319066 |
> | 319066 |
> | 319066 |
> +--------+
> 3 rows in set (0.30 sec)
>
> Actually I try switching codigo, RAND() or viceversa but doesn't work
> either.
>
> As you can see once I use the RAND() option doesn't group codigo, I need
> this because most of the articles are more than 10 but I really need to
> solve this problem.
>
> Hope anybody can help me.
>
> Thanks in advance.
>
> Angel
>
>
Each of those 3 lines have a different rand(), so it is doing it right.
---------------------------------------------------------------------
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