I'm trying to build this query to give me the element that the sequence number is the greatest value.
I have two records:
New York 1
I need to select the DST_NM with the MAX(SEQ_NUM).
Select DST_NM , MAX(SEQ_NUM) FROM Table
GROUp by DST_NM
= Cleveland 2
I don't know what I'm doing wrong :)