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 ordes and i
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