去除重复记录:select distinct xb as '性别' from test_student;select distinct 字段 as '别名' from 数据表名如果要去除多条,在后面加上逗号再添加相应字段就可以了。