SELECT A.*, B.total_cost, B.total_son_cost
FROM sso_user AS A, sso_user_fee AS B
WHERE A.userid = B.userid
AND A.user_type = 2
ORDER BY sum(B.total_cost + B.total_son_cost) DESC这条语句不能按sum的和去排序,而且只能查询一条记录出来!多谢请帮忙一下,比较急!
FROM sso_user AS A, sso_user_fee AS B
WHERE A.userid = B.userid
AND A.user_type = 2
ORDER BY sum(B.total_cost + B.total_son_cost) DESC这条语句不能按sum的和去排序,而且只能查询一条记录出来!多谢请帮忙一下,比较急!
解决方案 »
- Incorrect string value: '\xE5\x93\x88%'' for column 'sqlWhere' at row 1
- 请问一个SQL语句统计对应多个记录,只选择其中一条记录的办法
- 请教一下,这两条SQL语句执行效率哪个高点
- 求教MYSQL无法启动问题
- 关于文件系统和数据库系统存储的问题。
- MySQL复制,主从日志都出现错误或警告
- mysql存储过程参数长度问题
- 备份mysql数据库的问题
- 数据库新手请教这样的数据库如何设计
- CentOS6.5把MySQL从5.1升级到5.6后,MySQL不能启动
- 求一sql语句???
- select查询数据出错,希望大家帮忙看看(空格的问题)。
FROM sso_user AS A, sso_user_fee AS B
WHERE A.userid = B.userid
AND A.user_type = 2
ORDER BY sum_total DESC
试一下.
SELECT A.userid, B.total_cost, B.total_son_cost, SUM( B.total_cost + B.total_son_cost ) AS 'Total'
FROM sso_user AS A, sso_user_fee AS B
WHERE A.userid = B.userid
AND A.user_type =2
GROUP BY A.userid, B.total_cost, B.total_son_cost
ORDER BY Total DESC
LIMIT 0 , 30