xplBoBo的博客

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...

SELECT id,GROUP_CONCAT(score) FROM testgroup GROUP BY id查询id相同的所有分数