Top

[MSSQL] MYSQLÀÇ LIMIT µû¶óÇϱâ. | Web-Programing
±è°æÈÆ (admin) | Html | 2012/10/30 16:02:39 | Á¶È¸:42058

MySql]----------------------------------
select * from igrid_ccn LIMIT 10, 5;

LIMIT Ãâ·Â ÇÒ Ã¹¹ø° Çà, Ãâ·Â ÇÒ °³¼ö
-----------------------------------------

MSSql]----------------------------------
select top 10 * from ( select top 20 * from board order by ref asc, re_step desc ) order by ref desc, re_step asc
-----------------------------------------
°øÀ¯Çϱâ
°øÀ¯Çϱâ
0
0
0


´ñ±ÛÀ» ºÒ·¯¿À´Â ÁßÀÔ´Ï´Ù.
¡ã ÀÌÀü±Û [Web] µ¿¿µ»ó »çÀÌÁî ÀÚµ¿ ¸®»çÀÌÁî ÇÏ´Â ¹æ¹ý. ±è°æÈÆ (admin) 2012-10-31 17:25:22
¡å ´ÙÀ½±Û [MYSQL]password ¹®Á¦ ¾ÈÁöÈì (hoomiyam) 2012-10-30 13:52:32