Archives of the TeradataForum
Message Posted: Thu, 16 Aug 2007 @ 14:40:41 GMT
<-- Anonymously Posted: Thursday, August 16, 2007 07:11 -->
I have a multiset table with duplicate rows. Rows with same values across all the columns.
Is it possible to find out, which record was inserted the last.
table A col1 col2 abc ghj abc ghj
Among the above two, I have to find out, which is the last inserted row.
Is there a way to find that out ?
note: in oracle, there is something as rowid, which is used for this.
Please help, if you have a solution.
Thanks a lot
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|