Questions about teradata-sql-assistant
Read more about teradata-sql-assistant
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)
Modify query with TRUNC, ADD_MONTHS, LAST_DAY from Teradata SQL so as to work on SQL Server?
I have line of code from Teradata SQL like below:
WHERE CAST(COL1 AS DATE) BETWEEN TRUNC(ADD_MONTHS(CURRENT_DATE, -6),'MM') AND LAST_DAY(ADD_MONTHS(CURRENT_DATE,-1))
And my question is how to modify ...
dingaro
Votes: 0
Answers: 1
How to calculate mean value per group in Teradata SQL?
have table in Teradata SQL like below:
SMS_ID | PRODUCT
-------------------
11 | A
22 | A
33 | A
87 | B
89 | B
14 | C
Column "SMS_ID" presents ID of SMS sent do cl...
dingaro
Votes: 0
Answers: 1
How to calculate mean number of something per client in Teradata SQL?
I have table in Teradata SQL like below:
SMS_ID | CLIENT_ID
-------------------
11 | 123
22 | 123
33 | 123
87 | 456
89 | 456
14 | 888
Column "SMS_ID" presents I...
dingaro
Votes: 0
Answers: 2
Teradata SQL assistant connect to SQL Server, set preferences in using a libraries
I have one specific problem. In my Teradata SQL Assistant, I am connecting to SQL Server. But if it is possible, for me it will be best work with standard libraries in Teradata, like when I write help...
Zuzana Kasáková
Votes: 0
Answers: 1