![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
xplBoBo
只要一定要,我就一定行。
展开
-
sql查询最后添加的值
SELECT DISTINCT s.fileUrl FROM (SELECT MAX(id) AS id FROM tbl_pay WHERE orderId = 201800859 GROUP BY `type` ORDER BY id DESC ) s WHERE s.orderId = 201800859 ORDER BY `id` DESC...原创 2019-04-09 10:42:14 · 381 阅读 · 0 评论 -
GROUP_CONCAT使用
SELECT id,GROUP_CONCAT(score) FROM testgroup GROUP BY id查询id相同的所有分数原创 2019-04-09 10:51:34 · 152 阅读 · 0 评论