What I’m trying to do is determine (Using Teradata SQL) if a person’s zip code has accidently been put on an address line. I’ve looked on various forums and I can’t find any similar questions. Ultimately, I would want to write something like: Any ideas? Target database is Teradata 13.x Answer If you want to inspect the entire column to
Tag: teradata
TeraData aggregate function
When I try to select couple of columns with count, I get the following error: Selected non-aggregate values must be part of the associated group My query is something like this. Answer If you’re after a count for each combination of COLUMN1 and COLUMN2: If you’re after a count of all records in the table: