oracle多个条件排序

select rownum,j.* from jxjkzb j order by pjnf asc,rownum desc

 

rownum	dm	mc	pjnf	xssqkssj	xssqjssj	fdyshkssj	fdyshjssj	xyshkssj	xyshjssj
7	104005	国家奖学金二等	2008	2009-02-02	2009-02-17	2009-02-18	2009-02-27	2009-02-28	2009-03-05
6	103069	由泉奖学金	2008	2009-02-01	2009-02-03	2009-02-05	2009-02-07	2009-02-24	2009-02-27
4	107024	峨山奖学金	2008	2009-02-01	2009-02-02	2009-02-04	2009-02-06	2009-02-07	2009-02-08
1	107024	峨山奖学金	2009	2009-02-01	2009-02-02	2009-02-03	2009-02-04	2009-02-06	2009-02-07
2	107024	峨山奖学金	2010	2009-02-02	2009-02-04	2009-02-12	2009-02-21	2009-02-23	2009-02-28
8	104011	宁海奖学金	2011	2009-02-03	2009-02-04	2009-02-06	2009-02-14	2009-02-19	2009-02-27
3	107024	峨山奖学金	2011	2009-02-01	2009-02-03	2009-02-06	2009-02-07	2009-02-15	2009-02-20
5	107024	峨山奖学金	2012	2009-02-01	2009-02-02	2009-02-04	2009-02-06	2009-02-18	2009-02-26