sql如何合并同一张表里的字段并去重计数?

2025-03-10 11:46:06
推荐回答(2个)
回答1:

SELECT 买家ID FROM order
UNION
SELECT 卖家ID FROM order

回答2:

select count( distinct( ids) ) from (select 买家ID ids from order union select 卖家ID from order);