3 Replies Latest reply: Jun 24, 2004 4:39 AM by 358352 RSS

    Select last rows

    358352
      Hello,

      I have a table that looks like:

      LAST_NAME FIRST_NAME STATUS
      --------- ---------- ------
      MEIER MICHAEL 1
      SCHMIDT THOMAS 2
      MEIER MICHAEL 2
      SCHMIDT THOMAS 1

      In this table I have how you can see rows with the same names. But the status is different sometimes. I want to know which row is inserted or updated at last time to every person. For example if "MEIER" with the status "1" and if "SCHMIDT" with the status "2" is inserted or updated at last then I want to select these rows. How can I do this?