<p>是不是按照名称归类,然后按照每个类里面的最小时间进行排序?</p><p>select a.名称,</p><p> a.时间</p><p> from 表名 as a</p><p> join (select REPLACE(名称,'ing','') as '分类名称',</p><p> min(时间) as '排序时间'</p><p> from 表名</p><p> group by REPLACE(名称,'ing','')) as b</p><p>on REPLACE(a.名称,'ing','') = b.分类名称</p><p> order by b.排序时间,b.分类名称</p>
|