oracleÖжÔÅÅÐòµÄ×ܽá

¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»­ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚÒ»ÐÐÊý¾Ý
¡¡¡¡select * from (select * from perexl order by
nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M') )C where rownum=1
¡¡¡¡--½µÐòÅÅÐò
¡¡¡¡select * from perexl order by zongrshu desc
¡¡¡¡--ÉýÐòÅÅÐò
¡¡¡¡select * from perexl order by zongrshu asc
¡¡¡¡--½«nullsʼÖÕ·ÅÔÚ×îÇ°
¡¡¡¡select * from perexl order by danwei nulls first
¡¡¡¡--½«nullsʼÖÕ·ÅÔÚ×îºó
¡¡¡¡select * from perexl order by danwei desc nulls last
¡¡¡¡--decodeº¯Êý±Ènvlº¯Êý¸üÇ¿´ó£¬Í¬ÑùËüÒ²¿ÉÒÔ½«ÊäÈë²ÎÊýΪ¿Õʱת»»ÎªÒ»Ìض¨Öµ
¡¡¡¡select * from perexl order by decode(danwei,null,'µ¥Î»ÊÇ¿Õ', danwei)
¡¡¡¡-- ±ê×¼µÄrownum·ÖÒ³²éѯʹÓ÷½·¨
¡¡¡¡select *from (select c.*, rownum rn from personnel c)where rn >= 1and rn <= 5
¡¡¡¡--ÔÚoracleÓï¾ärownum¶ÔÅÅÐò·ÖÒ³µÄ½â¾ö·½°¸
¡¡¡¡--µ«ÊÇÈç¹û, ¼ÓÉÏorder by ÐÕÃû ÅÅÐòÔòÊý¾ÝÏÔʾ²»ÕýÈ·
¡¡¡¡select *from (select c.*, rownum rn from personnel c order by ³öÉúÄêÔÂ)where rn >=
1and rn <= 5
¡¡¡¡--½â¾ö·½·¨£¬ÔÙ¼ÓÒ»²ã²éѯ£¬Ôò¿ÉÒÔ½â¾ö
¡¡¡¡select *from (select rownum rn, t.*from (select ÐÕÃû, ³öÉúÄêÔÂ from personnel order
by ³öÉúÄêÔÂ desc) t)where rn >= 1and rn <= 5
¡¡¡¡--Èç¹ûÒª¿¼Âǵ½Ð§ÂʵÄÎÊÌ⣬ÉÏÃæµÄ»¹¿ÉÒÔÓÅ»¯³É£¨Ö÷ÒªÁ½ÕßÇø±ð£©
¡¡¡¡select *from (select rownum rn, t.*from (select ÐÕÃû,³öÉúÄêÔÂ from personnel order
by ³öÉúÄêÔÂ desc) t where rownum <= 10) where rn >= 3
¡¡¡¡--nvlº¯Êý¿ÉÒÔ½«ÊäÈë²ÎÊýΪ¿Õʱת»»ÎªÒ»Ìض¨Öµ,ÏÂÃæ¾ÍÊǵ±µ¥Î»Îª¿ÕµÄʱºòת»»³É“µ¥Î»ÊÇ¿Õ”
¡¡¡¡select * from perexl order by nvl(danwei,'µ¥Î»ÊÇ¿Õ')