用SQL查询不重复的字段

 一个表Teachers

两个字段identifier,Name

Name可以重复.要求查出不重复的字段.

 

1.如果只显示一个字段Name

select distinct [Name] from Teachers

select  [Name] from Teachers group by [Name]

2.如果要显示两个字段,则只能用

select min(identifier), [Name] from Teachers group by [Name]

如果用select distinct [Name],identifier from Teachers则不行,

因为distinct是要Name和identifier字段都重复才被筛选

据说还有其它方法,正在思考.......