SQL question.

  I have a simple question, suppose I have a table below:

  NAME RENTED DATE

  Bob     A      03/29/98
  Bob     A      05/19/99
  Joe     D      12/19/98
  Barb    E      03/09/99
  Barb    C      06/19/99
  Barb    E      09/05/98

  How do I just retrieve the most recent rows (by date)   for each person? Thanks.

ie.
  NAME RENTED DATE

  Bob     A      05/19/99
  Joe     D      12/19/98
  Barb    C      06/19/99

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 26 1999 - 20:54:07 CDT