SELECT ServerName , MAX(ServerVersion) FROM Servers GROUP BY ServerName Cheers Ken
From: Kevin Lundy [mailto:[email protected]] Sent: Friday, 5 March 2010 11:09 PM To: NT System Admin Issues Subject: Re: OT: Excel question If doing in Excel - Sort by Column A, insert subtotal for every change in Column A, change the function to Max, add subtotal (now Max) to column B. Now collapse the outline to level 2. On Fri, Mar 5, 2010 at 9:36 AM, Christopher Bodnar <[email protected]<mailto:[email protected]>> wrote: Anyone know how to do this in Excel or Access? I've got two columns. Column A has a server name and column B has a version number. There are multiple entries for each server. What I am trying to do is query by highest version number. For example: SERVER1 2.2 SERVER1 3.4 SERVER2 2.0 SERVER2 4.2 What I'd like to return is this: SERVER1 3.4 SERVER2 4.2 Thanks ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
