Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 16 Aug 2007 @ 16:21:43 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Working with duplicate rows
 
From:   Michael Larkins

Each row in a table contains a rowid (64 bits long). We use to be able to select and compare on it. However, that is not the case anymore. I believe I read somewhere that the DBS Control is used to specify whether or not you can use this column - by default, you cannot use it. Since the developers of Teradata are using it more and more internally, they have discouraged us from using it.

Regardless, if they are truly duplicate rows, hypothetically, does it really matter which one was inserted last?


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020