按城市分组 并且结果中不出现为空值的workcity
初始查询
SELECT *from student GROUP BY workcity
SELECT *from student where workcity !='' GROUP BY workcity //workcity为字符型字段
按城市分组 并且结果中不出现为空值的workcity
初始查询
SELECT *from student GROUP BY workcity
SELECT *from student where workcity !='' GROUP BY workcity //workcity为字符型字段