python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - teradata

Is it possible to calculate the total sum within partition and cumulative sum between partitions?

I am interested in calculating a descending cumulative sum based on groups, however, I want the cumulative sum to be based on the grouping. In other words, I want the total sum within a group and cumu...
test-img

nwaldo

sql

sql-server

tsql

teradata

Votes: 0

Answers: 3

Latest Answer

It's possible. No partition in the SUM OVER, just an order by group_id. select * , [CumSum] = sum(value) over(order by group_id desc) from data order by group_id desc; group_id value CumSum ...
test-img

LukStorms

Teradata queries to python

I like to get each teradata query used in my teradata database into my python program. Is there any way of doing that? By running the code we should be able to get teradata DDL and DML commands used a...
test-img

SAMBHU SUBRAMANNIAN

python

database

migration

teradata

Votes: 0

Answers: 0

How do I get transactions amount > 1000 of all months in SQL

I have been trying to pull customers who have transaction amount greater than 1000 in all months. This is what I have tried so far. But it doesn't look like it's working when I do individual customer ...
test-img

Ben

sql

teradata

Votes: 0

Answers: 3

Latest Answer

Select customer ,extract(month from trans_date) as mth ,extract(year from trans_date) as yr ,sum(trans_amount) as amt from transaction -- filter only those months you want to check, e.g. where ...
test-img

dnoeth

How to enquote the thr exported csv columns using Teradata Tdload utility?

I am using the Tdload utility of Teradata to extract data from database to a csv file. The syntax which I have used in the command line is: tdload --SourceTdpid 192.168.xx.xxx --SourceUserName dbc --S...
test-img

krx

teradata

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs