°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
SCORE ÇÔ¼ö´Â ãÀº ´Ù¸¥ ¹®¼¿Í ºñ±³ÇÏ¿© ¹®¼°¡ °Ë»ö °ªÀ» ¸¸Á·½ÃŰ´Â Á¤µµ¸¦ Ç¥½ÃÇÏ´Â Àý´ë °ªÀÔ´Ï´Ù. °ªÀº ¹®¼ÀÇ Å©±â¿¡ °ü·ÃÇÏ¿© ¹®¼¿¡¼ ÀÏÄ¡µÈ Ƚ¼ö¸¦ Ç¥½ÃÇÕ´Ï´Ù. ´ÙÀ½ ¿¹¿¡¼, SCORE ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ãÀº ¹®¼ÀÇ ¼øÀ§¸¦ °¡Á®¿Ã ¼ö ÀÖ½À´Ï´Ù.
WITH TEMPTABLE(docid,score) AS (SELECT docid, SCORE(COMMENT,'"book"') FROM DB2EXT.TEXTTAB) SELECT * FROM TEMPTABLE WHERE score > 0 ORDER BY score ASC
SCORE ÇÔ¼ö´Â 0¿¡¼ 1 »çÀÌÀÇ DOUBLE °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.
Âü°í |
---|
ºä¿¡¼ ÀÛ¼ºµÈ À妽ºÀÇ °æ¿ì CONTAINS, SCORE ¹× NUMBEROFMATCHES °Ë»ö ÇÔ¼ö¸¦ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. ºÐ»ê DB2 ȯ°æ¿¡¼´Â SCORE °ªÀÌ ´Ù¸¨´Ï´Ù.
|