|
||
0
0
ÈÄÆÛ2
±×·¸°Ô´Â ºÒ°¡´ÉÇϱ¸¿ä
UNION, IF, TEXTÄõ¸®µîÀ¸·Î ¸¸µå¼Å¾ßÇÒ°Í °°³×¿ä. select * from AA table wehre X < 5 AND aa = X UNION select * from AA table wehre X > 4 AND bb = X |
0
0
ModernLife
unionÀ¸·Î´Â ÇØ°áÀÌ ¾ÈµÇ°í µý°É »ý°¢ÇغÁ¾ß°Ú³×¿ä.
|
0
0
Oris-O
whereÀý¿¡ ÀÖ´Â°É select Àý·ÎÇϸé
select * ,case when x < 5 then x end as aa , case when x >4 then x end as bb from AA ; ÀÌ·±½ÄÀ¸·Î Çؼ aa¿Í bb¸¦ ±¸ÇÒ¼ö Àֳ׿ä ÀÏ´Ü ¹üÀ§°¡ ÀÌ»óÇؼ ÇÑ case ¹®¿¡´Â ´ãÀ»¼ö°¡ ¾øÀ»°Í °°¾Æ¿ä À§ÀÇ °æ¿ì¶ó¸é aa¸¸ °ªÀÌ ³ª¿À°Ú³×¿ä. ¹«¾ùÀ» ¹°¾îº¸´ÂÁö¸¦ ¾Ë¾Æ¾ß Äõ¸®°¡ ³ª¿Ã°Í°°¾Æ¿ä. |
0
0
ModernLife
AAÅ×ÀÌºí¿¡ aa,bb ¼Ó¼ºÀÌ ÀÖ°í °ª¿¡ µû¶ó¼ ºñ±³¸¦ µÎ±º´ë·Î ÇÏ°í½Í¾ú´Âµ¥ ¾ÈµÇ´Â°Í °°±º¿ä..
´äº¯°¨»çÇÕ´Ï´Ù. |
0
0
ÁøÇà
select *
from AA table where aa =( case when x < 5 then x end) or bb = ( case when x > 4 then x end) |
0
0
ModernLife
À̹æ¹ýÀÌ ÀÖ¾ú±º¿ä °¨»çÇÕ´Ï´Ù!
|
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |
and x = (0~9 Áß¿¡ Çϳª)
Áú¹®ÇÏ½Ã´Â°Ô ÀÌ°Ô ¸Â´ÂÁö ¸ð¸£°Ú³×¿© ¤¾¤¾ 0~9¿¡¼ ¹Þ´Â°Ô ·£´ýÀΰ¡¿ä?
Äõ¸®·Î ÇϽǰŸé MSSQL ±âÁØ¿¡¼± ÇÔ¼ö(FUNCTION) ¸¸µå¼Å¼Å ÇؾßÇÕ´Ï´Ù.