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

2007-02-16 Thread Joel Nimety
Maybe I should rephrase this in the form of a question :) I have a table with workstations and timestamps. I'd like to select the record with the most recent timestamp for each workstation. I know there is a simple query to accomplish this but I'm having difficulty. Does anyone have any

Exclude duplicates except most recent using GROUP BY and HAVING

2007-02-09 Thread Joel Nimety
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 current. I don't really care why there are duplicates but only need to a query to exclude the duplicate records (leaving the