MS-SQL ·Î ¾î¶»°Ô DB¸¦ ¸· ½ÃÀÛÇÑ Ãʺ¸ ÀÔ´Ï´Ù.
¿©±âÀú±â µÚÁ®¼ Çϱâ¿Í °°Àº Äõ¸®¹®À» ¸¸µé¾ú½À´Ï´Ù.
À̰͵éÀ» Union À¸·Î 'ÀÏÀÚ' ±âÁØÀ¸·Î ÇÕÄ¡±â Çؼ Á¤¿ÇÏ°í ½ÍÀºµ¥¿ä
ÀÚ²Ù Çϱâ¿Í °°Àº ¿¡·¯°¡ ³³´Ï´Ù ¤Ð °³º°·Î Äõ¸®Çϸé Àß °¡Á®¿À´Âµ¥ ¸»ÀÌÁ® ¤Ð
"¸Þ½ÃÁö 8120, ¼öÁØ 16, »óÅ 1, ÁÙ 1
¿ 'Observances.ObservanceTime'ÀÌ(°¡) Áý°è ÇÔ¼ö³ª GROUP BY Àý¿¡ ¾øÀ¸¹Ç·Î SELECT ¸ñ·Ï¿¡¼ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù."
°í°ßÀ» ±â´Ù¸®°Ú½À´Ï´Ù ¤Ð¤Ð
//Äõ¸®//
select Datepart(day,dateAdd(hour,0,ObservanceTime)) as 'ÀÏÀÚ', sum(ObservanceCount) as 'FTP'
from Observances, SecurityChecks
where ObservanceType=1
and Observances.SecChkID=SecurityChecks.SecChkID
and SecurityChecks.tagname like 'FTP%'
and observancetime between '2015-01-01 00:00:00' and '2015-01-31 23:59:59'
union
select Datepart(day,dateAdd(hour,0,ObservanceTime)) as 'ÀÏÀÚ', sum(ObservanceCount) as 'SSH'
from Observances, SecurityChecks
where ObservanceType=1
and Observances.SecChkID=SecurityChecks.SecChkID
and SecurityChecks.tagname like 'SSH%'
and observancetime between '2015-01-01 00:00:00' and '2015-01-31 23:59:59'
group by Datepart(day,dateAdd(hour,0,ObservanceTime))
order by 'ÀÏÀÚ'
Àâ´ã | 1209¸íÀÌ Àоú¾î¿ä. 18.188.137.58