Re: Return Most Recent Record PER CLIENT

[Mark Murphy]

It's tricky, but here's one way.  I know this works in Oracle.  I forget if it works in SQL.

try this:
SELECT cn, date, score
FROM table
WHERE (cn, date) IN (
  SELECT cn, MAX(date) AS date
  FROM table
  GROUP BY cn
)

note that you could have a duplicate with this method if two dates were exactly the same.  

HTH.
-Mark

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---