Hi,
Below is cut and paste off a Select Query output. I'm trying to eliminate the duplicate dates. To provide some context, our company runs some data and then it's saved and loaded to Teradata. In the example below, you can see we have multiple dates (7/9/2019 shows up twice and et cetera) and the reason being is the data (awto_228) was loaded to Teradata, but, then the planner realized she made a mistake and loaded another corrected case (awto_243 - hence the duplicate dates). I can't have the other case (awto_228) scrubbed from the database so what I want is to take the max case name to get my unique row value. However, when I do a MAX in the select query on case name nothing happens. Could someone please help me with this?
Thanks,
Mike
PlantName StartDateTime StreamCode StreamRow PETROStreamDescription NUmber1 Number2 Number3 MaxOfCaseName NAME ABC 7/9/2019 abc.def LMNO..W Sour Grapes 3.38032618 1091.12535 -72.5027321 awto_228 ESE 2019 July M1 ABC 7/9/2019 abc.def LMNO..W Sour Grapes 3.88569597 1250.10222 -76.7584626 awto_243 ESE 2019 July M1 ABC 7/10/2019 abc.def LMNO..W Sour Grapes 3.27577072 1057.09121 -68.5873664 awto_228 ESE 2019 July M1 ABC 7/10/2019 abc.def LMNO..W Sour Grapes 3.77450824 1214.32347 -76.7276515 awto_243 ESE 2019 July M1 ABC 7/11/2019 abc.def LMNO..W Sour Grapes 3.27577072 1057.09121 -68.5873664 awto_228 ESE 2019 July M1 ABC 7/11/2019 abc.def LMNO..W Sour Grapes 3.77450824 1214.32347 -76.7276515 awto_243 ESE 2019 July M1 ABC 7/12/2019 abc.def LMNO..W Sour Grapes 3.77450824 1214.32347 -76.7276515 awto_243 ESE 2019 July M1 ABC 7/12/2019 abc.def LMNO..W Sour Grapes 3.27577072 1057.09121 -68.5873664 awto_228 ESE 2019 July M1 ABC 7/13/2019 abc.def LMNO..W Sour Grapes 3.77450824 1214.32347 -76.7276515 awto_243 ESE 2019 July M1