DB/M$SQL
간단한 where 날자 검색
단독질주
2007. 8. 12. 18:40
SELECT TOP 10 IP, RefSearch, COUNT( * ) RefCount
FROM tblURL
WHERE CONVERT(VARCHAR, CurDate, 112) BETWEEN '20070614' AND '20070617'
GROUP BY IP, RefSearch
ORDER BY RefCount DESC
FROM tblURL
WHERE CONVERT(VARCHAR, CurDate, 112) BETWEEN '20070614' AND '20070617'
GROUP BY IP, RefSearch
ORDER BY RefCount DESC