#DateForumTypeThreadPost
925 Jan 2016 @ 03:09 PSTDatabaseTopicHow to find out items sold by one or multiple Sellers using indicator flag? Hi, There are 3 tables ITEM(Item_id, Item_title), SELLER(Seller_id,Seller_name), ITEMSELLER(Item_id,Seller_id), where i have to findout the Items that are sold by only one sel...
827 Aug 2015 @ 12:17 PDTDatabaseReplyOrder by month name in Chronological order SELECT * FROM databasename.t_monthname  ORDER BY month_name (DATE, FORMAT 'mmm')
709 Jul 2015 @ 09:18 PDTDatabaseReplyIssue while casting BYEINT column to TimestampThanks Fred, it worked.
603 Jul 2015 @ 05:25 PDTDatabaseTopicIssue while casting BYEINT column to TimestampHi, I am trying to derive a TIMESTAMP(0) FORMAT 'yyyy-mm-ddbhh:mi:ss'. I have DATE(cre_dt) part in one column and HOUR(cre_hr), MIN(cre_min), SEC(dispute_case_cre_sec) part each in 3 ...
529 Jun 2015 @ 08:35 PDTDatabaseReplyProblem with history tableHi Dieter, We will be moving to TD14 soon. Thanks a lot Dieter, you made my day. Sitara  
428 Jun 2015 @ 04:53 PDTDatabaseReplyProblem with history tableHi Dieter, Thanks for the inputs, The query is working as expected. The data is in production, and i have to repeat the same functionality for 4 other columns, which will consume more cpu as resul...
328 Jun 2015 @ 02:05 PDTDatabaseReplyProblem with history tableWe are using teradata 13.0. Is there any way we can do without using Last_Value, becoz in 13 version we dont have that fucntion Thanks Sitara
228 Jun 2015 @ 12:07 PDTDatabaseTopicProblem with history tableHi, I am trying to build history table which contains all the changes for a event. The columns(column_s, column_o, column_m , column_r) are from 4 different tables which describe the events for a p...
109 Dec 2014 @ 04:07 PSTTrainingTopicHelp on Teradata real time scenario interview questionsHi, Iam new to Teradata and looking for job as Teradata Developer, can some one help me on where can i get the real time scenario interview questions on Teradata. Thank you in advance.