过滤重复数据 1.select distinct sp_name as spName,sp_logo as spLogo from sp_info; 查询出来的是spName和spLogo全部不重复的数据,即过滤掉spName和spLogo都重复的数据 2.select sp_name as spName,sp_logo as spLogo from sp_info group by sp_name; 查询出来的是spName不重复的数据,即过滤掉的是spName重复的数据