Question

sql sever 创建视图后，查询全是重复的一条数据，怎么处理？

Answer 1

CREATE VIEW 人员 AS (SELECT * FROM X) UNION (SELECT * FROM Y) 只要把 all 去掉 就可以了

Answer 2

分组关键字，group by 会去掉重复值