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 > > > >
