关于GroupBy写法 返回
SqlSugar
沟通中
1
92

悬赏:0 飞吻
SELECT A.[tcmNO], MAX(A.[CaseId]), MAX(A.[CompanyId]) FROM ( SELECT (CASE p.[TcmOrderNO] WHEN '' THEN p.[Id] ELSE p.[TcmOrderNO] END ) AS tcmNO, p.* FROM [hcrm_v3_db].[dbo].[px_Prescriptions_20250101] p INNER JOIN px_PrescriptionRefunds_20250101 pr ON p.[Id] = pr.[PrescriptionId] WHERE pr.[RefundNO] > 1 ) A GROUP BY A.[tcmNO]
上面收sql用sqlsugar如何写写?
热忱回答(1)
-
fate sta VIP0
1个月前看文档:嵌套查询
0 回复