Exclude duplicates except most recent using GROUP BY and HAVING

May 05 13:37:29 EDT 2006 CYB1| 000F20D0272D-453E8A1B-0365-CEED-02D6| CAL_LAPTOP | Fri Feb 09 09:46:09 EST 2007 CYB1| 00508BE171F3-4587E84F-0540-56B8-003D| CFWRKSTATION| Tue Feb 06 16:14:03 EST 2007 ... -- Joel Nimety Product Architect 203.5

Re: Exclude duplicates except most recent using GROUP BY and HAVING

e have any suggestions? Am I posting on the correct list to get this answered? Thanks. Joel Nimety wrote: > The default "host" table can possibly have multiple records for a given > workstation. Presumable the duplicate records are for historical > purposes, but only one is actually