ORACLE
HOME > DB > ORACLE
2009.01.07 / 18:35

Mysql limit¸¦ Oracle Äõ¸®·Î ¹Ù²ãº¸ÀÚ - MSSQL top

Á¤¿øÁö
Ãßõ ¼ö 1695
Á¦¸ñ¾øÀ½ Mysql limit¸¦ Oracle Äõ¸®·Î ¹Ù²ãº¸ÀÚ

 

select
    rownum   ,     FZIP_NO      ,    BZIP_NO       ,    SZIP_NO       ,    ADDRD_NM ,  ..........µîµî
from   ( select *
        from SHLOWN.ZT_ZIPCODE )
where rownum between 1 and 10
order by (Á¤·ÄÄ÷³) desc