3 Replies Latest reply: Nov 29, 2007 1:01 AM by Dieter W. RSS

    how to select the max rowid from a subquery with group by

    452722
      Hi Gurus,
      Kindly help how to fix the following query because I'm getting Oracle error:ORA-01446.

      select * from edy_raw_data a
      where rowid in ( select max(rowid) from(
      select email,max(date_updated) from edy_raw_data b
      where b.email=a.email
      group by email ))

      The query select the max rowid from a sub query with group by.

      Thanks in Advance.

      Benjie