表
|ID |uin |nickname|
|----|----|----|
|1 |1234 |张三|
|2 |1234 |张三|
|3 |1234 |张三|
| 4 |1234 |张三|
| 5 |1234 |张三|
|6 |2345 |李四|
|7 |2345 |李四|
|8 |2345 |李四|
|9 |2345 |李四|
|10 |2345 |李四|
|11 |3456 |王五|
目标结果
|uin_count |nickname |uin|
|----|----|----|
|5 |张三 |1234|
|4 |李四 |2345|
|1 |王五 |3456|
现在只会如下sql<br>SELECT COUNT(uin) as uin_count,nickname<br>FROM Commin<br>GROUP BY nickname<br>ORDER BY COUNT(uin) desc<br>
希望有人帮解答，谢谢
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 1929 days ago, the information mentioned may be changed or developed.
 |
1
liujavamail Feb 7, 2021
这样不就可以了么?
|
 |
2
anonymous2022 OP @liujavamail 结果里没有显示 uin
|
 |
3
NotFoundEgg Feb 7, 2021
SELECT COUNT(uin) as uin_count,nickname,uin
FROM Commin GROUP BY nickname,uin ORDER BY COUNT(uin) desc 这样？ |
 |
4
fiypig Feb 7, 2021
加个 uin 不就可以了
|
 |
5
c6h6benzene Feb 7, 2021 via iPhone
作业还是要自己完成…
|
|
6
anonymous2022 OP @NotFoundEgg 是我愚笨了，谢。
|
 |
7
PAwang Feb 7, 2021
。。。 草 这不就是加个 uin 就行了吗
|
Select Language