我有一個客戶表，想選擇具有多個地址的客戶。
我創建了以下查詢，但Customer_ID = 105具有相同地址和不同帳戶的客戶包含在我的結果集中。
select *
from [Customer]
where Customer_ID in (select [Customer_ID]
from [Customer]
group by [Customer_ID]
having count(*) > 1)
uj5u.com熱心網友回復：
select *
from [Cutomer]
where Customer_ID in (
select [Customer_ID]
from [CuatomerA]
group by [Customer_ID]
having count(distinct [Address]) > 1
)
uj5u.com熱心網友回復：
您可以使用視窗函式，這可能比使用自聯接更有效
SELECT *
FROM (
SELECT *,
count = COUNT(*) OVER (PARTITION BY Customer_ID)
FROM Customer c
) c
WHERE count > 1;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/436643.html
上一篇：在SQL中連接表時如何避免重復
下一篇：在同一張表上自加入后加入一張表