Question : I have a list of 463 CARRIER_CD. I am attempting to retrieve the most current BILL_DT for each […]
Tag: teradata
Normalization of Time Series Data
Question : I have a table containing various a/b test experiment performance on a daily basis. The table structure looks […]
SQL to return preferred duplicate rows
Question : Have a data set that some rows have a duplicate. Looking to return the row with IND = […]
Teradata: How to design table to be normalized with many foreign key columns?
Question : I am designing a table in Teradata with about 30 columns. These columns are going to need to […]
Group multiple rows with different column values to a single row
Question : I have 3 records with 3 column values for the same key. PFB sample data. CREATE TABLE student […]
Teradata 15: Failed [5315 : HY000] An owner referenced by user does not have SELECT WITH GRANT OPTION access to DBC.RoleMembersV.RoleName
Question : I am using Teradata 15. Using a powerful database user sysdba, I created the following view: REPLACE VIEW […]
Best practice – use of derived table or use the original table in join?
Question : Imagine I have the following tables in Teradata : TableA : Field1|Field2|Field3 TableB : Field1|Field4|Field5 I am trying […]
Teradata Join Syntax
Question : I’m having a hard time doing what I want to do here, as SQL (and Teradata SQL on […]
Aggregating spend by customer where accounts can be re-assigned to different customers
Question : I want to join unique customer ids with their spends. Problem: The account_no can be assigned to a […]