#DateForumTypeThreadPost
1018 Feb 2010 @ 09:56 PSTDatabaseReplyTo get a latest record in teradata tableYou can get the latest record using an identity column. If u have identity column like timestamp then u can get the latest record as max(timestamp) group by PI values. If you don't have any thing l...
901 Feb 2010 @ 07:13 PSTDatabaseReplyrownum in teradatahi ravi...thanks for u r quick response..I don't have column like modified_ts to get the latest record...Before, there is an identity column in the table by which we can get the latest record..But ...
801 Feb 2010 @ 06:17 PSTDatabaseTopicrownum in teradatahi,i want to get rid of duplicate rows in teradata table..for example if i have a table with the following fields customerid customename customeraddress 1 mac ok...
722 Jan 2010 @ 07:59 PSTDatabaseTopicsql statement to convert hundred year date to yyyy-mm-dd formathi ,i need to write a sql statement to convert hundred year date to 'yyyy-mm-dd' formatfor example a hundred year date 40196 is equal to 2010-01-19can any one give me an idea how to do this using s...
618 Jan 2010 @ 11:19 PSTToolsReplydelete & insert vs updatethanks for helping me out....
518 Jan 2010 @ 11:19 PSTToolsTopichow to insert no of rows effected by a sql stmt in bteq script into a table with in the same scripthican any one tell me how to insert the number of rows effected by a sql statement in a bteq script in to a table..can i activitycount for this....i want to insert the number of records inserted wi...
416 Jan 2010 @ 04:03 PSTToolsTopicdelete & insert vs updatehi all,can anyone tell me the best way in updating a record ( with efficiency)delete & insert or update
314 Jan 2010 @ 11:20 PSTToolsTopicinserting data into one table from multiple tableshi i need to insert data into one table from 2 different tablesi m using like thisinsert into table1 values(firstname,phoneno,lastname)select fname,(select t2.phonenumber from table2 t2,table3 t3 w...
203 Dec 2009 @ 05:52 PSTToolsReplyany one plz give me brief explain about this errori believe that your table definition has secondary index. If that is the case then drop the table re create with out the secondary index and use mload to load the data and then add the secondary in...
103 Dec 2009 @ 05:44 PSTToolsTopicerror 6760 and 2679hi i am trying to load data from a pipe delimited file in to a table using fast load. All the rows are going to error table and the error table showing the error codes as 2679 and 6760 on two colum...