Mysql SELECT语句按计数顺序排列

Question

I am not sure if this is possible or not

I have a table with orders and userid

I need to do a SELECT query with ORDER BY the least number of orders of a customer

Example:

userid1 has 10 orders
userid2 has 5 orders

Then SELECT should show userid2 at the top

Thanks in advance

Answer 1

If you have orders as ordersCount i mean as a field which keeps counts of orders then

Select * FROM YourTable order by orders ASC

Else if you have a record for each order then

Select * FROM YourTable Group by UserID order by count(*) ASC;

Apply limit like this

Select * 
     FROM YourTable 
     Group by UserID 
     order by count(*) ASC 
     limit startIndex, fetchSize;

where startIndex and fetchSize are int that define your limit