Question

sql 过滤重复记录并按倒序排列

sql 过滤重复记录并按倒序排列

Answer 1

Select Max(id) As Id,Title From TableName Group By Title Order By Id DescDistinct是去掉完全相同的记录,因为你的id不同,所以没用.我是这样理解的,按id降序排序,按Title分组,相同的取ID最大,能达到你要的效果,查询不止一个字段时,其他字段分别加上Max()或者Min()Select Max(id) As Id,Title,Max(FiledA),Max(FiledB) From TableName Group By Title Order By Id Desc

Answer 2

用分组语句查询就可以了，这样就可以不重复select 字段,count(*) as XXX from table where 条件 group by 字段 order by 2