Very well, Works, thanks.
-Mensaje original-
De: Ananda Kumar [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 01 de octubre de 2007 13:16
Para: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Asunto: Re: Querry Count Rows
can u please give sample data.
If the same city has more than one
can u please give sample data.
If the same city has more than one order_id then, you could use this
select city,count(*) "total" from table group by city order by total desc
limit 10;
regards
anandkl
On 10/1/07, Tomas Abad <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
>
>
> I have a table with orde
Hi all,
I have a table with ordes and i want to know the top 10 Citys have the most
ordes. This is my table
Order_id, City
Need count the rows where haver the most similar text y the column City?
Thanks all