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 h
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
HI All,
I have a Table and want to know the most visited products.
Products
- Id
- Name
- Visited
Visited is numeric.
