SELECT DISTINCT oct1, oct2, oct3, oct4 
INTO #tempCheckIP
FROM ipLog
WHERE timestamp BETWEEN '2006/01/01' AND '2006/02/01'

SELECT oct1, oct2, oct3, count(oct4) AS [Count]
FROM #tempCheckIP
GROUP BY oct1, oct2, oct3
ORDER BY [Count] DESC

DROP TABLE #tempCheckIP