sql查询最后添加的值

最新推荐文章于 2025-01-06 13:45:39 发布

原创最新推荐文章于 2025-01-06 13:45:39 发布 · 461 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一种使用SQL查询特定orderId下，当type值相同时获取fileUrl最后添加的值的方法。通过子查询和联表查询，可以有效地从数据库中筛选出所需的信息。

	    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最后添加的值