union

-- union 会对所有重复对内容去重
select
    category
from
(
    select
        1 as category
    union all
    select
        1 as category
)tmp

union
    select
        1 as category

https://data.bytedance.net/aeolus/#/queryEditor/query/653d49344bb79ca8?appId=36&blockId=2577646&group=default&taskId=15767855

全部评论

相关推荐

点赞 收藏 评论
分享
牛客网
牛客企业服务