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
'DB > M$SQL' 카테고리의 다른 글
| Alter Table (0) | 2008.05.21 |
|---|---|
| MSSQL DB 복구 후 사용자 계정 매칭 (0) | 2008.04.11 |
| 저장 프로시저 (Store Procedure) 예제 (0) | 2007.05.30 |
| MSSQL connect for Windows 2003 (0) | 2007.05.19 |
| MSSQL connect for Windows 2003 (0) | 2007.05.18 |