#DateForumTypeThreadPost
2315 Apr 2016 @ 10:57 PDTGeneralReplyHow to sum up the columns total value in the last rowHello, Can anyone help me how would I bring this "Column Wise" sum as below highlighted in bold : using GROUPING SETs via Case Staments (If required)in the Query....Kindly refer to my pr...
2214 Apr 2016 @ 07:53 PDTGeneralReplyHow to sum up the columns total value in the last rowHello dieter, yea I'm trying to modify the code using grouping sets. I can use partition by "column name " but the problem is that the other columns in select clause (apart from the ...
2114 Apr 2016 @ 10:35 PDTDatabaseReplyCOUNT () OVER (PARTITION BY) and DISTINCTHi All , In the same example as above , I will have to calculate the column wise "SUM" as mentioned in 'Bold" in the example below. (col1) (Date1) (Date2) ...
2014 Apr 2016 @ 10:33 PDTGeneralReplyHow to sum up the columns total value in the last rowHi All , In the same example as above , I will have to calculate the column wise "SUM" as mentioned in 'Bold" in the example below. (col1) (Date1) (Date2) ...
1914 Apr 2016 @ 06:33 PDTDatabaseReplyCumulative Sum by distinct customer ID by yearHello All , Hi All , In the same example as above , I will have to calculate the column wise "SUM" as mentioned in 'Bold" in the example below. (col1) (Date1) (Date2) (Sum for...
1807 Apr 2016 @ 12:44 PDTGeneralReplyHow to sum up the columns total value in the last rowHello Dieter , Thank You, yes I would like to view Cust, date columns and pull the other 7-8 dimension columns from my source table. But the Sum calculated should do the aggregation only on CUST a...
1707 Apr 2016 @ 12:43 PDTDatabaseReplyCumulative Sum by distinct customer ID by yearExactly thought the same. Thanks ton for clarifying. Regards, Shavyani
1606 Apr 2016 @ 11:25 PDTGeneralReplyHow to sum up the columns total value in the last rowHello Dieter, Yes it's correct, but don't we have to use partition by here or a simple case as above would work? Please Advise. Thanks in Advance :) Thanks Regards, Shavyani.
1506 Apr 2016 @ 11:21 PDTDatabaseReplyCumulative Sum by distinct customer ID by yearThanks ton Atar and  Yuvae I shall implement this and get back. Yuvae a small clarfication I would like to have , here is the union all clauses is being done based on the Cust value but if de...
1405 Apr 2016 @ 07:36 PDTDatabaseReplyCumulative Sum by distinct customer ID by yearHello Folks,   I have a requirement and should bring d data in below format (col1) (Date1) (Date2) (Sum for days1-10.) (Sum days11-20) (sumdays21-30)    Total A.     &...
1305 Apr 2016 @ 07:34 PDTGeneralReplyHow to sum up the columns total value in the last rowHello Folks,   I have a requirement and should bring d data in below format (col1) (Date1) (Date2) (Sum for days1-10.) (Sum days11-20) (sumdays21-30)    Total A.     &...
1205 Apr 2016 @ 07:28 PDTDatabaseReplyCOUNT () OVER (PARTITION BY) and DISTINCTHello Folks,   I have a requirement and should bring d data in below format (col1) (Date1) (Date2) (Sum for days1-10.) (Sum days11-20) (sumdays21-30)    Total A.     &...
1112 Nov 2015 @ 10:09 PSTDatabaseReplyOREPLACE Hello Carlos, Steve , I get your point , but my data is not a hardcoded value instead, the issue now is there is a table t1 and it has Column (say Column1) data itself is of the...
1028 Oct 2015 @ 07:50 PDTDatabaseReplyOREPLACE Hello Steve , Carlos , Thanks for your valuable suggestions.  I l try and get back!   Regards , Shavyani
928 Oct 2015 @ 07:09 PDTDatabaseReplyOREPLACE Hello Folks , I just have a column data of the form : 'a','b','c','d' I want to use Oreplace and replace it with  / symbol so that the resultant would be ...
828 Oct 2015 @ 06:59 PDTDatabaseReplyCASE statement in WHERE clauseHello Folks , I just have a requirement with  the dynamic "Where" clause : Scenario : There are 2 hardcoded values : Selection1: yes No Selection 2: Yes ...
718 Oct 2015 @ 10:31 PDTDatabaseReplyOrder by DateHello , we have been developing reports , we have a "Select query with multiple joins and columns , retrieved from a report , but when we run the same query  in teradata the sort differ...
601 May 2015 @ 12:47 PDTDatabaseReplySelecting with WHERE clause leads to all-row scan . Hello All, I have a query1: select columns names from (queries with left outer join WHERE QTR_WK_NUM IN(valuessss....) UNION query.... WHERE QTR_WK_NUM IN(valuess...
501 May 2015 @ 12:44 PDTUDAReplyUsing qualify and group by togetherThanks Dieter :)
407 Apr 2015 @ 10:48 PDTData ModelingReplyCan Teradata display the Quarter value of a date?Hi folks, Im finding an issue handling these quarter dates in terdata. My requirement is to fetch the Q1 and Q2 for current year and previous year in a single query and this query I will be using...
302 Apr 2015 @ 07:46 PDTDatabaseReplyNeed to convert Rows to columns Hello guys, I'm having a Table  which looks like ID   AMT  MONTH A    5          201501 A  ...
222 Mar 2015 @ 07:17 PDTUDAReplyUsing qualify and group by togetherThanks ton for your suggestion. These columns (column1),(column2),(column3),(column4) in the tool we use will come as a "promt" to the users for them to enter their required "s...
120 Mar 2015 @ 11:18 PDTUDAReplyUsing qualify and group by togetherHello Folks, Im trying many work arounds for this issue, my requirement is : we have a tool which fetches the "Select" clause columns dynamically based on user input, and onething to no...