日期:2014-05-16  浏览次数:20634 次

求一mysql语句!!!
求mysql语句,请各位大虾指点:
表users中字段
id name moneyto
1 a 500.5
2 b 200
3 c 500
4 d 200
5 a 600.5
6 b 500
7 c 300.5
8 d 100
查出表中moneyto总和最多的用户的name以及与之对应moneyto的总和.

------解决方案--------------------
好像是没有哦,不好意思,不是不加就可以了?用别的别名。
SQL code

mysql> select * from users;
+----+------+---------+
| id | name | moneyto |
+----+------+---------+
|  1 | a    | 500.500 |
|  2 | b    | 200.000 |
|  3 | c    | 500.000 |
|  4 | d    | 200.000 |
|  5 | a    | 600.500 |
|  6 | b    | 500.000 |
|  7 | c    | 300.500 |
|  8 | d    | 100.000 |
+----+------+---------+
8 rows in set (0.00 sec)

mysql> select  * from  (select   name,sum(moneyto)as   moneyto   from   users
  group   by     name) as a order   by   moneyto   desc limit 0,1;
+------+----------+
| name | moneyto  |
+------+----------+
| a    | 1101.000 |
+------+----------+
1 row in set (0.00 sec)