关于Sql Server 连接查询结果重复的问题
0
最佳答案
0
理解了一下你的需求，你试试以下语句
select a.name, a.age, b.school from table1 a join (select distinct name from table2 where city='北京') b on a.name=b.name where a.china='中国' and a.height between 160 and 200
收获园豆：5
其他回答(4)
0
select distinct a.name, a.age, b.school from table1 a
left join table 2 b on a.name=b.name where b.city = '北京' and a.china='中国' and
a.height '160' and '200'
a.height '160' and '200'
0
select distinct * from
(select a.name, a.age, b.school from table1 a
left join table 2 b on a.name=b.name where b.city = '北京' and a.china='中国' and
a.height '160' and '200'
a.height '160' and '200'
)
t1
0
select distinct * from table
0
select distinct * from table
distinct去重复
