#DateForumTypeThreadPost
1211 May 2006 @ 07:26 PDTAnalyticsReplyAny equivalent pseudo columns in TD like ROWNUM in OracleThe below query will return 100 rows in increasing order of col1.select col1 , col2 . . , row_number() over (order by col1) as row_numfrom tablenamequalify row_num
1108 May 2006 @ 03:23 PDTDatabaseReplySomething in Teradat as is CONNECT BY in Oracleselect item , sales , sum(sales) over () total_sum , sum(sales) over (rows unbounded preceding) as cum_sum , (cum_sum-sales)*100/total_sum as start_cum_perc , (case when start_c...
1003 May 2006 @ 01:06 PDTDatabaseReplyUpdating a particular character in a fieldSathya,From your problem description, it seems that this is one time fix that you want to apply. If this is correct then you can fix this in following ways: -1. The solution you mention works only ...
902 May 2006 @ 01:06 PDTDatabaseReplySubstr causing problem-killing query performanceYou might want to define col3 as value order NUSI for improving the performance.But, it is a good practice to keep the substring data substr(col3,10,2) and substr(col3,15,2) as separate columns in ...
802 May 2006 @ 12:45 PDTDatabaseReplyYear and Month only fieldPlease write down your requirement for this field, how/where you want to use this field. There can be many solutions and we can find the best solution best on requirements.Thanks.
701 May 2006 @ 04:12 PDTDatabaseReplyYear and Month only fieldYou can define your column as INTERVAL type, example below: -Create Table xyz( ... ,cre_month interval year(4) to month ,...);Insert into xyz( ... ,cre_month ,...)values( ... ,'2006-02' ,...);H...
601 May 2006 @ 03:54 PDTDatabaseTopicBenefit of collect stats on non-index columnsI was wondering what is the benefit of collecting statistics on Non-Primary Index and Non-Secondary Index columns. Isn't the search on this column always full table scan even if stats is collected ...
517 Feb 2006 @ 03:27 PSTDatabaseReplycan insert the derived table in Between clause?Why BETWEEN not working and comparison operator working is probably because of their syntax. Given below is thier syntax as given in Teradata manuals.1. Syntax of BETWEEN is: -expression1 BETWEEN e...
416 Feb 2006 @ 08:12 PSTDatabaseReplyImport from MS XLS (EXCEL) file to teradata table.This is what Queryman help has to say on import rules: -The Import file must be a delimited text file containing data values that are separated from each other by the delimiter character specified ...
316 Feb 2006 @ 07:54 PSTTrainingReplyHow many Certified Teradata MastersThanks for the information ! What is the name of your office and where it is? .. I am just kidding.I posted that question because i wanted to know if i complete the master certification, i will be ...
226 Jan 2006 @ 12:37 PSTTrainingTopicHow many Certified Teradata MastersHi,Can anyone tell me, approx how many Certified Teradata Masters are there in total.Regards,Sunil
124 Jan 2006 @ 12:01 PSTDatabaseTopicTablename can be deifned in where clauseI just noticed something in Teradata. We can define a table in the WHERE clause. For example the below query run without any error from the p****r: -select * from personnelwhere personnel1.user_id ...