GENDER : ¼ºº°
sort : {DESC, ASC}
orderBy : {AGE, GENDER}
SELECT * FROM DUAL
ORDER BY {orderBy} {sort}
´ëÃæ À§¿Í °°Àº Çʵå¿Í Äõ¸®°¡ ÀÖ´Ù°í ÇÒ ¶§,
À§ ORDER BY ´ÙÀ½ {} ¿¡ µé¾î°¡´Â orderBy¿Í sort ¸¦ µ¿ÀûÀ¸·Î º¯È¯ ÇÒ ¼ö ÀÖ´Â ¹æ¾ÈÀÌ ÀÖ´ÂÁö Áú¹®µå¸³´Ï´Ù.
($ ¾²´Â°Å ¸»°í)
Á¦°¡ ¿øÇÏ´Â ½ÄÀº (orderBy ¿¡ age, sort ¿¡ desc ³Ö¾úÀ» °æ¿ì)
SELECT * FROM DUAL ORDER BY #{orderBy} #{sort}
=> ¿¹»ó °á°ú °ª
SELECT * FROM DUAL ORDER BY AGE DESC
ÀÔ´Ï´Ù.
$¸¦ ¾µ °æ¿ì ¹Ù·Î ¹ÚÇô¼ »ç¿ëÀÌ °¡´ÉÇÑ°Å °°Àºµ¥ # Àº ÅؽºÆ®°¡ ¾Æ´Ï°¡
°ªÀ¸·Î Ãë±ÞÇؼ ¾ÈµÇ´Â°Å °°Àºµ¥ ¹æ¾ÈÀÌ ÀÖ´ÂÁö
Áú¹® µå¸³´Ï´Ù.
¾Æ´Ï¸é ÇØ´ç ÄÉÀ̽ºº°·Î Á¤·ÄÁ¶°ÇÀ» ´Ù ¸¸µé¾îÁÖ¾î¾ßÇÒÁö..
Áú¹® | 2553¸íÀÌ Àоú¾î¿ä. 13.58.121.214