create table #
(
name varchar(10)
)
insert #
select 'AAA' union all
select 'BBB' union all
select 'AAA'select distinct * from # order by namedrop table #
(
name varchar(10)
)
insert #
select 'AAA' union all
select 'BBB' union all
select 'AAA'select distinct * from # order by namedrop table #
SELECT distinct Tbage.uid ,Tbcompany.province , Tbcompany.city , TbCompany.company
FROM Tbage inner join TbCompany on Tbage.uid=tbcompany.uid order by newid()
为什么要用newid() 排序呢?为了取得乱序?