默认排序
code type
01 B
01 C
02 A
02 B
02 C
02 D
排序以后
code type
01 B
02 B
01 C
02 C
02 A
02 D 请教排序以后的sql应该怎么写呢
code type
01 B
01 C
02 A
02 B
02 C
02 D
排序以后
code type
01 B
02 B
01 C
02 C
02 A
02 D 请教排序以后的sql应该怎么写呢
select * from tth1 a left join
(SELECT type,min(id) as newid from tth1 group by type order by min(id) asc) b
on a.type=b.type
order by newid,code