sql - select records with max(rowid) from a select with group by field -


i have query this:

select aa, bb, cc, dd, ee, ff, gg, hh, ii, ll, mm table1 group aa, bb, cc, dd, ee; 

now, want select field don't compare in group by, records max rowid. i'm on postgres , rowid equivalent ctid?.

which equivalent rowid in postgresql? how it? thanks

i not sure mean, add max(ctid) select list.

two caveats:

  1. that not make sense.

  2. ctid quite different oracle's rowid since postgresql's row versioning works differently. after each update, row can have different ctid.


Comments