select a.rowid, a.* from table_xyz a where a.rowid > (select min(b.rowid) from table_xyz b where b.some_column = a.some_column);
I eventually found that by aliasing ROWID, it will display in Toad. For example:
select a.rowid as show_me ...There's also a way to perform various clicks in the correct spot of the Data Grid to enable the display of ROWID... But the alias is easier to explain here...
No comments:
Post a Comment