distinct关键字用在整个记录行上。
select distinct a,b from
(select 'a' a, 'b' b from dualunion allselect 'a' a, 'b' b from dual) t
本文共 175 字，大约阅读时间需要 1 分钟。
distinct关键字用在整个记录行上。
select distinct a,b from
(select 'a' a, 'b' b from dualunion allselect 'a' a, 'b' b from dual) t
转载于:https://www.cnblogs.com/javaeye235/p/5895062.html