|
|
Archives of the TeradataForum
Message Posted: Wed, 30 Jul 2008 @ 10:40:51 GMT
Subj: | | Re: How to achieve ROWID in Teradata |
|
From: | | sreenivasa.akula |
Hi Nimmala,
Please find query and result below
sel empno,rowid from odsadm.emp (V2R5.0 Demo)
EMPNO ROWID
1006 0000555500BE00000100
1008 0000C6486FFA00000100
1002 0000736E224500000100
6001 0000C25B6CD200000100
1005 00009FDBC81F00000100
1004 0000E461918100000100
3003 00002DDEC0F400000100
1007 000010CF375C00000100
1003 000029E859E300000100
3001 0000BCEA51B800000100
1001 0000B8F4EAA600000100
| |