23 | 15 Apr 2016 @ 10:57 PDT | General | Reply | How to sum up the columns total value in the last row | Hello,
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... |
22 | 14 Apr 2016 @ 07:53 PDT | General | Reply | How to sum up the columns total value in the last row | Hello 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 ... |
21 | 14 Apr 2016 @ 10:35 PDT | Database | Reply | COUNT () OVER (PARTITION BY) and DISTINCT | 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) ... |
20 | 14 Apr 2016 @ 10:33 PDT | General | Reply | How to sum up the columns total value in the last row | 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) ... |
19 | 14 Apr 2016 @ 06:33 PDT | Database | Reply | Cumulative Sum by distinct customer ID by year | Hello 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... |
18 | 07 Apr 2016 @ 12:44 PDT | General | Reply | How to sum up the columns total value in the last row | Hello 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... |
17 | 07 Apr 2016 @ 12:43 PDT | Database | Reply | Cumulative Sum by distinct customer ID by year | Exactly thought the same. Thanks ton for clarifying.
Regards,
Shavyani |
16 | 06 Apr 2016 @ 11:25 PDT | General | Reply | How to sum up the columns total value in the last row | Hello 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.
|
15 | 06 Apr 2016 @ 11:21 PDT | Database | Reply | Cumulative Sum by distinct customer ID by year | Thanks 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... |
14 | 05 Apr 2016 @ 07:36 PDT | Database | Reply | Cumulative Sum by distinct customer ID by year | Hello 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. &... |
13 | 05 Apr 2016 @ 07:34 PDT | General | Reply | How to sum up the columns total value in the last row | Hello 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. &... |
12 | 05 Apr 2016 @ 07:28 PDT | Database | Reply | COUNT () OVER (PARTITION BY) and DISTINCT | Hello 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. &... |
11 | 12 Nov 2015 @ 10:09 PST | Database | Reply | OREPLACE |
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... |
10 | 28 Oct 2015 @ 07:50 PDT | Database | Reply | OREPLACE | Hello Steve , Carlos ,
Thanks for your valuable suggestions. I l try and get back!
Regards ,
Shavyani
|
9 | 28 Oct 2015 @ 07:09 PDT | Database | Reply | OREPLACE | 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
... |
8 | 28 Oct 2015 @ 06:59 PDT | Database | Reply | CASE statement in WHERE clause | Hello Folks ,
I just have a requirement with the dynamic "Where" clause :
Scenario :
There are 2 hardcoded values :
Selection1:
yes
No
Selection 2:
Yes
... |
7 | 18 Oct 2015 @ 10:31 PDT | Database | Reply | Order by Date | Hello ,
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... |
6 | 01 May 2015 @ 12:47 PDT | Database | Reply | Selecting 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... |
5 | 01 May 2015 @ 12:44 PDT | UDA | Reply | Using qualify and group by together | Thanks Dieter :)
|
4 | 07 Apr 2015 @ 10:48 PDT | Data Modeling | Reply | Can 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... |
3 | 02 Apr 2015 @ 07:46 PDT | Database | Reply | Need to convert Rows to columns | Hello guys,
I'm having a Table which looks like
ID AMT MONTH
A 5 201501
A  ... |
2 | 22 Mar 2015 @ 07:17 PDT | UDA | Reply | Using qualify and group by together | Thanks 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... |
1 | 20 Mar 2015 @ 11:18 PDT | UDA | Reply | Using qualify and group by together | Hello 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... |