求SQL语句 货物表 goods( g_id int, quality int, person_id int ) 其中person_id是person表的主键,表示货物拥有人。 需求: 求拥有货物数量最多的前10名人物。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 贴记录及要求结果出来看看,TRYSELECT person_id,SUM(quality) FROM TT GROUP BY person_id ORDER BY SUM(quality) DESC LIMIT 10 quality 只是个质量代号,再想想看: 拥有货物数量最多的前10名人物 select person_id,count(*)from goodsgroup by person_idorder by 2 desclimit 10 select person_id,count(g_id) num from goods group by person_id order by num desc limit 10 没有看到你的记录SELECT person_id,count(*) FROM TT GROUP BY person_id ORDER BY count(*) DESC LIMIT 10 +---------+---------+-----------+-| g_id | quality | person_id |+---------+-----------+---------+-| 9 | 0 | 50003 || 17 | 0 | 50003 || 40 | 0 | 50001 || 73 | 0 | 50002 || 86 | 0 | 50003 || 140 | 0 | 50002 || 150 | 0 | 50001 || 158 | 1 | 50001 |像这里 ,person 50001就拥有3个物品,person 50002就拥有2个物品,明白了吗? SELECT person_id,count( distinct g_id) FROM TT GROUP BY person_id ORDER BY count( distinct g_id) DESC LIMIT 10 你好,朋友,解释下 order by 2 desc 是什么意思好不?我就这个没想到 mysql 行列转换 如何将一篇文章的内容,里面有图也有文字存在一个字段里面??? CSDN 也是用的MYSQL ? 这个sql语句应该怎么改进? cmd 进入mysql row_count()用mysql_affected_rows()获取后值一直为-1 mysql如何实现connect by with功能? 数据库性能效率提问.(在线等待中..) 大量数据的关系问题? 同时计算同一字段的两种计算方法结果 mysql查询语句问题(急) 大虾们,这个问题怎样解决(我是新手)
SELECT person_id,SUM(quality) FROM TT GROUP BY person_id ORDER BY SUM(quality) DESC LIMIT 10
quality 只是个质量代号,再想想看: 拥有货物数量最多的前10名人物
from goods
group by person_id
order by 2 desc
limit 10
SELECT person_id,count(*) FROM TT GROUP BY person_id ORDER BY count(*) DESC LIMIT 10
| g_id | quality | person_id |
+---------+-----------+---------+-
| 9 | 0 | 50003 |
| 17 | 0 | 50003 |
| 40 | 0 | 50001 |
| 73 | 0 | 50002 |
| 86 | 0 | 50003 |
| 140 | 0 | 50002 |
| 150 | 0 | 50001 |
| 158 | 1 | 50001 |
像这里 ,person 50001就拥有3个物品,person 50002就拥有2个物品,明白了吗?
你好,朋友,解释下 order by 2 desc 是什么意思好不?我就这个没想到