ÅÅÐòÓ÷¨ order by asc desc

µ¥¸ö×Ö¶ÎÅÅÐò

select c1,c2,c3 from table order by 3 asc

¶à×Ö¶ÎÅÅÐò

select c1,c2,c3 from table order by 2 asc,3 desc

°´ÕÕ×Ó´®ÅÅÐò

select substr(c1,1,3) c2 from table order by c2 asc