SELECT * , count(`order_id`) FROM (SELECT `number` , `account` , `order_id` , date(`upload_date`)
FROM `1_sale_orders`
WHERE date( `upload_date` ) >= '$startdate' AND date( `upload_date` ) <= '$enddate'
GROUP BY `order_id` ) t
GROUP BY `number`
ORDER BY `account` ASC请问这个我怎么排序date(`upload_date`)字段??
FROM `1_sale_orders`
WHERE date( `upload_date` ) >= '$startdate' AND date( `upload_date` ) <= '$enddate'
GROUP BY `order_id` ) t
GROUP BY `number`
ORDER BY `account` ASC请问这个我怎么排序date(`upload_date`)字段??
解决方案 »
- mysql禁止修改栏位数据
- 关于My SQL的 Access denied.
- MySQL流入流出带宽的监控
- mysql 存储过程乱码问题 50分 在线等。。谢谢
- 存储过程中怎样把结果集查询出来,并把值CONCAT成字符串输出
- 求SQL语句:判断并替换查询结果
- 急~~~~~~~~~~~~~~~~~~~老版本mysql数据库数据想转出到sql server,怎么办???
- MySQL4.0.15在那裡下載
- 紧急情况~~~~!!如何恢复mysql数据库!!高手帮忙啊!!!
- mysql.users里面, root用户的 host设为 % ,所有机器都可以连接; 那么,怎么能“只让特定的10多个IP访问、使用mysql呢” ?
- MySQL问题
- mysql 数据库无法启动INNODB 怎么办求高手解决
FROM `1_sale_orders`
WHERE date( `upload_date` ) >= '$startdate' AND date( `upload_date` ) <= '$enddate'
GROUP BY `order_id` ) t
GROUP BY `number`
ORDER BY `ud` ASC
FROM `1_sale_orders`
WHERE date( `upload_date` ) >= '$startdate' AND date( `upload_date` ) <= '$enddate'
GROUP BY `order_id` ) t
GROUP BY `number`
ORDER BY 4 ASC