摘要: 分页 declare @page intdeclare @size intset @page=1 --第几页set @size=2000 --一页多少条 SELECT id FROM (select * from zmaction_back where order_id in (SELECT B.o 阅读全文
posted @ 2021-07-14 09:21 枫岫 阅读(40) 评论(0) 推荐(0) 编辑
摘要: SELECT B.order_id,order_status_list FROM (SELECT order_id,(SELECT CAST(order_status as varchar)+',' FROM zmaction WHERE order_id=A.order_id order by o 阅读全文
posted @ 2021-07-14 09:10 枫岫 阅读(300) 评论(0) 推荐(0) 编辑