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