取最新记录,该如何解决

取最新记录
SELECT   MAX(a.LogAddtime)   AS   LogAddtime,   a.LogUserID,  
            b.IpArea
FROM   ManViewLogs   a   INNER   JOIN
          ViewLogIPs   b   ON   a.IpId   =   b.IpId
GROUP   BY   a.LogUserID,   b.IpArea
ORDER   BY   MAX(a.LogAddtime)   DESC

结果如：  
LogUserID             IpArea                           LogAddtime
-1四川省成都市电信       2007-04-02   15:14:00
36本机地址                         2007-04-02   15:06:00
-1北京市网通       2007-04-02   11:36:00
-1本机地址                         2007-04-02   10:55:00
-1北京市中国网通       2007-04-02   10:54:00
-1广东省深圳市长城宽带   2007-04-02   10:43:00
-1北京市电信       2007-03-30   17:19:00
-1四川省成都市       2007-03-30   10:19:00
-1广东省深圳市       2007-03-30   00:15:00
55北京市中国网通       2007-03-30   00:15:00
555北京市中国网通       2007-03-30   00:15:00
5555北京市中国网通       2007-03-29   13:48:00

我只想根据LogAddtime取LogUserID最新的一条记录   该怎么取？
要的结果是
LogUserID             IpArea                           LogAddtime
-1四川省成都市电信       2007-04-02   15:14:00
36本机地址                         2007-04-02   15:06:00
55北京市中国网通       2007-03-30   00:15:00
555北京市中国网通       2007-03-30   00:15:00
5555北京市中国网通       2007-03-29   13:48:00

分不多，还望见谅


[解决办法]
SELECT MAX(a.LogAddtime) AS LogAddtime, a.LogUserID,b.IpArea
FROM ManViewLogs a INNER JOIN
ViewLogIPs b ON a.IpId = b.IpId
inner join (select LogUserID,MAX(LogAddtime) AS LogAddtime FROM ManViewLogs group by LogUserID) c
on a.LogUserID=c.LogUserID and a.LogAddtime=c.LogAddtime
GROUP BY a.LogUserID, b.IpArea
ORDER BY MAX(a.LogAddtime) DESC
[解决办法]
---try
SELECT id identity(int,1,1),MAX(a.LogAddtime) AS LogAddtime, a.LogUserID,
b.IpArea into #tmp
FROM ManViewLogs a INNER JOIN
ViewLogIPs b ON a.IpId = b.IpId
GROUP BY a.LogUserID, b.IpArea

select * from #tmp
where a.id=(select top 1 id from #tmp where LogUserID=a.LogUserID order by LogAddtime desc )