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 DISTINCT fileUrl
FROM tbl_pay
WHERE `id` IN((SELECT MAX(`id`) AS `id` FROM tbl_pay WHERE orderId = 201800718 GROUP BY `type`))
ORDER BY `id` DESC
查询某个orderId ,当type值相同时 fileUrl最后添加的值