¾È³çÇϼ¼¿ä.
»óȲ¿¡ µû¶ó¼ ´Ù¸¦ ¼ö ÀÖ°ÚÁö¸¸¿ä.
¾Æ·¡ Äõ¸®¹®Àº
¿ë¾î(Terms) Å×ÀÌºí¿¡¼ TItle Çʵ忡 Áߺ¹ ÀúÀåµÈ
¿ë¾î¸¦ °¡Á®¿À´Â Äõ¸® »ùÇÃÀÔ´Ï´Ù.
À̸¦ Âü°íÇؼ
ÀÀ¿ëÇغ¸½Ã±â ¹Ù¶ø´Ï´Ù.
--[?] Áߺ¹ µ¥ÀÌÅÍ °¡Á®¿À±â
--[1] Áߺ¹ÀÎ °Í °¡Á®¿À±â
Select Title From Terms
Group By Title Having Count(Title) > 1
GO
--[2] Áߺ¹ÀÎ °Íµé °¡Á®¿À±â
Select Title From Terms
Where Title
In (Select Title From Terms Group By Title Having Count(Title) > 1)
Go
±èÁø¸¸ ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä °»ç´Ô.
SQL ±¸¹®Áß Áߺ¹À» Á¦°ÅÇÏ´Â ±¸¹®ÀÎ distinct ¿Í ¹Ý´ëµÇ´Â ±¸¹®À» ¾Ë°í ½Í½À´Ï´Ù.
Áï, distinct´Â Áߺ¹À» Á¦°ÅÇؼ ±× °á°ú°ªÀÌ ³ª¿À´Âµ¥¿ä
ÀÌ¿Í´Â ¹Ý´ë·Î ¾î¶² ·¹Äڵ尡 Áߺ¹ÀÌ µÈ ·¹ÄÚµåÀÎÁö¸¦ ¾Ë°í½ÍÀ»¶§´Â ¾î¶² ±¸¹®À» »ç¿ëÇÏ´ÂÁö¿ä? Áߺ¹µÈ °ªÀÌ µé¾î°¡Áö ¾Ê¾Æ¾ß ÇÒ µ¥ÀÌÅ͸¦ °Ë»öÇÒ¶§ À¯¿ëÇϸ®¶ó »ý°¢µÇ¾î¼ ¿©Âã´Ï´Ù.
Áñ°Å¿î ÇÏ·ç µÇ¼¼¿ä~~
|