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 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 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 > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]