2009.01.07 / 18:35
Mysql limit¸¦ Oracle Äõ¸®·Î ¹Ù²ãº¸ÀÚ - MSSQL top
Á¤¿øÁö
Ãßõ ¼ö 1695
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
[Ãâó] Mysql limit¸¦ Oracle Äõ¸®·Î ¹Ù²ãº¸ÀÚ |ÀÛ¼ºÀÚ ÇãÇã