Linux Information
 
ÃÑ °Ô½Ã¹° 31°Ç, ÃÖ±Ù 0 °Ç
   
MySQLÀÇ Order By ¹® »ùÇÃ
±Û¾´ÀÌ : ½Å¿µÃ¶ ³¯Â¥ : 2012-05-10 (¸ñ) 15:20 Á¶È¸ : 12633

SELECT column_name(s)
 FROM table_name
ORDER BY column_name(s) ASC  /* ¿À¸§Â÷¼ø */


SELECT column_name(s)
 FROM table_name
ORDER BY column_name(s) DESC  /* ³»¸²Â÷¼ø */

SELECT column_name(s)
FROM table_name
ORDER BY column1, column2  /* Á¶°Ç1(column1) ¸¸Á·ÇÏ¸é ¼­ºêÁ¶°Ç(column2)À¸·Î Á¤·Ä */

½Å¿µÃ¶ ´ÔÀÇ MySQL ÃÖ½Å±Û [´õº¸±â]


   

 

naver.com daum.net nate.com google.co.kr youtube.com


Copyright ¨Ï www.pronice.com. All rights reserved.