Returning the most recent logon for each user

• Gabe Banens

  Grasshopper

  Points: 11

  More actions

  July 10, 2002 at 3:51 am

  #78534

  My apologies if this is simple but it seems to have me stumped.

  My database has an audit log table that records all transactions in a linked application. As part of reporting requirements I need to find out the most recent date that each person has logged on to the system. The audit log holds records of every logon but I can't seem to return the most recent logon for each distinct user?

  Could anyone offer any advice?

  Thanks in advance

  Gabe.

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  July 10, 2002 at 3:56 am

  #432323

  select max(logdate)

  from table

  group by username