27,579
社区成员
发帖
与我相关
我的任务
分享
select t.*
from
(
select ROW_NUMBER() over(order by tb_crm_order_union.create_time desc) as rowId,tb_crm_order_union.id,tb_crm_order_union.username,[CRM_CONFIG].[dbo].[a_user].mobile,[CRM_CONFIG].[dbo].[a_user].email,tb_crm_order_union.item_code,tb_crm_order_union.start_time,tb_crm_order_union.pay_fee,tb_crm_order_union.due_time,DATEDIFF(day,tb_crm_order_union.start_time, tb_crm_order_union.due_time) buy_time
from tb_crm_order_union
INNER JOIN (SELECT max(due_time) max_due_time,username FROM tb_crm_order_union GROUP BY username) t on tb_crm_order_union.username = t.username
inner join [CRM_CONFIG].[dbo].[a_user] on tb_crm_order_union.username=[CRM_CONFIG].[dbo].[a_user].username
where 1=1 ' + @filter + '
) as t
where t.rowId >= ' + LTRIM(@startNo) + ' and t.rowId <= ' + LTRIM(@endNo);