SQL0490N | SQL¹®¿¡ Á÷Á¢ ÁöÁ¤µÈ ¼ýÀÚ "<number>"°¡ ÀÌ ÄÁÅؽºÆ®("<minval>", "<maxval>")¿¡¼ Çã¿ë°¡´ÉÇÑ °ªÀÇ ¹üÀ§¸¦ ¹þ¾î³µ½À´Ï´Ù. |
¼³¸í: ¼ýÀÚ("<number>")°¡ ÁöÁ¤µÈ ÄÁÅؽºÆ®¿¡¼ À¯È¿ÇÏÁö ¾Ê°Ô ÁöÁ¤µÇ¾ú½À´Ï´Ù. |ÀÌ ÄÁÅؽºÆ®¿¡¼ ÃÖ¼Ò Çã¿ë °ªÀº "<minval>"ÀÔ´Ï´Ù. |ÀÌ ÄÁÅؽºÆ®¿¡¼ ÃÖ´ë Çã¿ë °ªÀº "<maxval>"ÀÔ´Ï´Ù. nÀº "<minval>" ¹× "<maxval>"·Î ÁöÁ¤µÈ |¹üÀ§ ³»¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù("<minval>" =< |n =< "<maxval>").
|»ç¿ëÀÚ ÀÀ´ä: ¸í·É¹®¿¡¼ °ª nÀ» ¿Ã¹Ù¸¥ °ªÀ¸·Î º¯°æÇϽʽÿÀ.
|sqlcode: -490
|sqlstate: 428B7
SQL20214N | ORDER OF "<table-designator>"°¡ ÁöÁ¤µÇ¾ú½À´Ï´Ù. ±×·¯³ª ÀÌ Å×À̺í ÁöÁ¤ÀÚ´Â Á¤·ÄµÇÁö ¾Ê½À´Ï´Ù. |
¼³¸í: ORDER OF ÀýÀº Á¤·ÄµÇÁö ¾ÊÀº |"<table-designator>"ÀÇ ¼ø¼¿¡ ±Ù°ÅÇÏ¿© °á°ú Å×À̺íÀÇ |¼ø¼¸¦ ÁöÁ¤ÇÕ´Ï´Ù. "<table-designator>"¿Í ¿¬°üµÈ Á¶È¸¿¡´Â ORDER BY ÀýÀÌ ¾ø°Å³ª, |ORDER BY ÀýÀÇ Á¤·Ä Å°°¡ »ó¼ö Ç¥Çö½ÄÀÔ´Ï´Ù.
|»ç¿ëÀÚ ÀÀ´ä: À¯È¿ÇÑ ORDER BY ÀýÀ» |"<table-designator>"¿Í ¿¬°üµÈ Á¶È¸¿¡ Ãß°¡Çϰųª, |ORDER OF ÀýÀ» »ç¿ëÇÏ´Â ´ë½Å Á¤·Ä Å° ½ºÆåÀ» »ç¿ëÇϽʽÿÀ.
|sqlcode: -20210
|sqlstate: 428FI
SQL20211N | ½ºÆå ORDER BY ¹× FETCH FIRST n ROWS ONLY°¡ ¿Ã¹Ù¸£Áö ¾Ê½À´Ï´Ù. |
¼³¸í: ORDER BY ¶Ç´Â FETCH FIRST n ROWS ONLY´Â ´ÙÀ½¿¡¼ Çã¿ëµÇÁö ¾Ê½À´Ï´Ù. |
|»ç¿ëÀÚ ÀÀ´ä: ORDER BY ¶Ç´Â FETCH FIRST n ROWS ONLY ÀýÀ» Á¦°ÅÇϽʽÿÀ. ORDER BY´Â ºä, ¿ä¾à Å×ÀÌºí ¶Ç´Â |SQL Å×À̺í ÇÔ¼ö¸¦ »ç¿ëÇÏ´Â Á¶È¸¿¡¼¸¸ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |FETCH FIRST n ROWS ONLYÀÇ È¿°ú´Â WHERE ÀýÀÇ ¼ú¾î¿Í ÇÔ²² |ROW_NUMBER() OVER() ÀýÀ» »ç¿ëÇÏ¿© ¹ß»ýµÉ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½°ú °°½À´Ï´Ù.
|SELECT name FROM | (SELECT ROW_NUMBER() OVER() AS rn name | FROM emp) AS e WHERE rn<10 |
|sqlcode: -20211
|sqlstate: 428FJ
|
SQLSTATE °ª | ÀÇ¹Ì |
428B7 | SQL¹®¿¡ ÁöÁ¤µÈ ¼ýÀÚ´Â À¯È¿ÇÑ ¹üÀ§¸¦ ¹þ¾î³µ½À´Ï´Ù. |
428FI | ORDER OF°¡ ÁöÁ¤µÇ¾úÁö¸¸, Å×À̺í ÁöÁ¤ÀÚ°¡ ORDER BY ÀýÀ» Æ÷ÇÔÇÏÁö ¾Ê½À´Ï´Ù. |
428FJ | ORDER BY´Â ºä ¶Ç´Â ¿ä¾à Å×À̺íÀÇ ¿ÜºÎ fullselect¿¡¼ Çã¿ëµÇÁö ¾Ê½À´Ï´Ù. |