8,497
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 1
cid
FROM ( SELECT c.ID AS CID ,
o.ID AS OID ,
COUNT(0) AS 'TCount'
FROM [customer] c
LEFT JOIN [order] o ON c.ID = o.ID
GROUP BY c.ID ,
o.ID
) t
ORDER BY TCount
这样?