[阅读: 425] 2007-03-28 13:46:07
SELECT TOP 10 ClientIP, logTime, DestHost, bytesrecvd, bytessent
FROM WebProxyLog
WHERE (ClientIP = '3232250947')
ClientIP logTime DestHost bytesrecvd bytessent
3232250947 2007-3-19 10:15:12 support.ap.dell.com 265 480
3232250947 2007-3-19 10:15:12 support.ap.dell.com 266 902
3232250947 2007-3-19 10:15:14 supportapj.dell.com 473 0
3232250947 2007-3-19 10:15:16 supportapj.dell.com 455 36086
3232250947 2007-3-19 10:15:16 i.dell.com 469 0
3232250947 2007-3-19 10:15:16 www.163.com 934 118094
3232250947 2007-3-19 10:15:17 adclient.163.com 882 1687
3232250947 2007-3-19 10:15:17 images.163.com 744 272
3232250947 2007-3-19 10:15:17 supportapj.dell.com 495 0
3232250947 2007-3-19 10:15:17 www.163.com 943 472
我想按Desthost统计bytesrecvd和bytessent,该怎么写?group by用的不熟。