通用方法: select distinct T1.name2,T1.name1 from table T1 innert join table T2 on t1.name1=T2.name1
通用方法: select distinct T1.name2,T1.name1 from table T1 inner join table T2 on t1.name1=T2.name1
select distinct name2 from tabbe where name1="亚洲" and name1="美洲"
select * from (select name2 from talbe where name1="亚洲" and name3="湖南省")as a,(select name2 from talbe where name1="美洲" and name3="旧金山")as b 不知道这样合不合你的意??
select distinct name2 from table
alter table tbname add column id identity(1,1) select * from tbname where id not in (select min(id) from tbname group by tbname) alter table drop column id
select distinct T1.name2,T1.name1 from table T1
innert join table T2 on t1.name1=T2.name1
select distinct T1.name2,T1.name1 from table T1
inner join table T2 on t1.name1=T2.name1
不知道这样合不合你的意??
select * from tbname where id not in (select min(id) from tbname group by tbname)
alter table drop column id