|
|
|
|
²ÀÁö / 2001-12-17 / ¿ÀÈÄ 12:08:03 / 147.6.140.128
Á¶È¸¼ö : 131
|
[Áú¹®] ³×Æ®¿öÅ© ±×·ìº°·Î.....y |
> ¹æ¹®ÀÚ Á¤º¸ Åë°è¸¦ ³»´Âµ¥
> ³×Æ®¿öÅ© ±×·ìº°·Î Åë°è¸¦ ³»·Á¸é ¾î¶»°Ô ÇØ¾ß ÇÏ´ÂÁö ¹¯°í ½Í½À´Ï´Ù..
> ¿¹¸¦ µé¾î 168.124.154.x ¸¦ ÇÑ ±×·ìÀ¸·Î ¹¾î¼ ¹æ¹®ÀÚ Á¤º¸¸¦ ³ªÅ¸³»·Á¸é ¾î¶² ½ÄÀ¸·Î ÇØ¾ß ÇÏ´ÂÁö ¾Ë°í ½Í½À´Ï´Ù.
> ±ÞÇÑ ÀÏÀÌ¶ó¼ ±×·±µ¥ ²À Á» °¡¸£ÃÄ Áֽʽÿä
-----------------------------------------------------------
col
-------------
192.168.1.1
192.168.1.2
192.168.3.0
192.168.2.0
192.178.2.1
211.181.157.44
----------------------
SELECT LEFT(col, 8) as 'ip´ë¿ª', Count(*) as 'ÇÕ°è'
FROM ip
Group By LEFT(col, 8)
°á°ú
---------------------
192.168.______ 4
192.178.______ 1
211.181.______ 1
°á°ú´Â ÀÌ·¸°Ô ³ª¿À´Âµ¥¿ä...
¿©±â¼ ¹®Á¦´Â
ip´ë¿ªÀÌ ²À ¼¼ÀÚ¸® ¼ýÀڷθ¸ ±¸¼ºµÇ´Â°Ô ¾Æ´Ï¶ó´Â °ÍÀÔ´Ï´Ù.
µû¶ó¼ µÎ¹ø° ´ë¿ª ±¸ºÐÀÚ(.)±îÁö¸¸À» ÀÐÀ» ¼ö ÀÖ´Â º°µµÀÇ Äõ¸® ¹®ÀåÀ» ¸¸µé¾î¾ß ¸ðµç °æ¿ì¸¦ ´ëóÇÒ ¼ö ÀÖ´Â Äõ¸® ¹®ÀåÀÌ µÇ°Ú³×¿ä..
¹Ùºü¼ ¸¶Á® ¿Ï¼ºÄ¡ ¸øÇ߳׿ä..
ÀÌÇØÇϽñæ... |
|
|