SQL同样的记录只显示一条

select Title from Products group by Title having count(*)=1 or count(*)>1
select DISTINCT Title from Products
最佳方法：select id,Title,smallpic from Products where id in (select max(id) from Products group by Title)