|
|||||
- File #1 : 120degree.jpg(17.6 KB), Download : 45 |
SQL Äõ¸® ±âÃʸ¸ ¾Æ´Â ÀÚÀÇ ´ä´äÇÔÀ» ¿©·¯ºÐ²² ³ª´¯´Ï´Ù^^ °£´ÜÇÑ Äõ¸® 2°³ÀÇ Ã³¸® ¼Óµµ°¡ ³Ê¹« ´Ù¸¥µ¥ ¹¹°¡ ¹®Á¦Àϱî¿ä? A. SELECT * From Å×À̺í WHERE °áÁ¦ÀÏ = #2020-05-18# and SettleType <> 'ÀÔ±Ý' and SettleType <> 'ȯºÒ' ORDER BY °áÁ¦½Ã°£ ASC B. SELECT * FROM Å×À̺í WHERE °áÁ¦ÀÏ = #2020-05-18# and (SettleType = 'ÀÔ±Ý' or SettleType = 'ȯºÒ') ORDER BY °áÁ¦½Ã°£ ASC Access DB±¸¿ä ·¹ÄÚµå´Â 55¸¸°Ç Á¤µµÀε¥ A Äõ¸®´Â °á°ú ·¹Äڵ尡 400¿©°³ Àε¥ ¼ø½Ä°£¿¡ ¶å´Ï´Ù. B Äõ¸®´Â °á°ú ·¹Äڵ尡 20°³ Á¤µµÀε¥ 50ÃÊ Á¤µµ °É¸³´Ï´Ù. Á¦°¡ ¹» À߸øÇÑ °É±î¿ä? |
|
| ||
| ||
| ||
| ||
| ||
| ||