mysqlÁ¤·Ä°ü·ÃÁú¹®µå¸³´Ï´Ù
|
2020.11.10 17:05:18
|
|
mysql Á¤·Ä °ü·Ã Áú¹®µå¸³´Ï´Ù
|
AGE : ³ªÀÌ
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
ÀÔ´Ï´Ù.
$¸¦ ¾µ °æ¿ì ¹Ù·Î ¹ÚÇô¼ »ç¿ëÀÌ °¡´ÉÇÑ°Å °°Àºµ¥ # Àº ÅؽºÆ®°¡ ¾Æ´Ï°¡
°ªÀ¸·Î Ãë±ÞÇؼ ¾ÈµÇ´Â°Å °°Àºµ¥ ¹æ¾ÈÀÌ ÀÖ´ÂÁö
Áú¹® µå¸³´Ï´Ù.
¾Æ´Ï¸é ÇØ´ç ÄÉÀ̽ºº°·Î Á¤·ÄÁ¶°ÇÀ» ´Ù ¸¸µé¾îÁÖ¾î¾ßÇÒÁö.. 3.133.112.203 |
Áú¹® | 2,624¸íÀÌ Àоú¾î¿ä. 3.133.112.203 | | 10
·¹¾î¡¤À¯¸Ó¡¤ÀÚÀÛ Àαâ±Û |
|
1 Á¤½Å³ª°¥°Å °°Àº ½ºÆÀ 19±Ý ¾Æ°× |
4½Ã°£ Àü |
|
|
|
|
1
ºñ°ø°³
|
|
Á¤·Ä Ä÷³¿¡ µû¶ó ½ÇÇà °èȹÀÌ ´Þ¶óÁö±â ¶§¹®¿¡ ±×³É ³¯Äõ¸® ³¯¸®´Â°Í°ú ´Ù¸¦¹Ù°¡ ¾øÀ» °Å °°¾Æ¼ °Á ³¯Äõ¸®¸¦ ³¯¸®°Ú½ººó´Ù (µýû)
|
2020/11/10 21:50
|
2
ºñ°ø°³
|
|
1/³× °¨»çÇÕ´Ï´Ù. ÄÉÀ̽ºº°·Î ±¸ºÐÇؾ߰ڳ׿ä..
|
2020/11/11 08:57
|
¸Þ´º
|
¸ñ·Ï |
¸ÇÀ§·Î |
·Î±×ÀÎ |