Subquery max sequence number
- by Andy Levesque
I'm hesitant to ask because I'm sure it's out there, but I just can't seem to come up with the keywords to find the answer. I'm stepping outside my boundaries by starting with subqueries (normally an Access user).
I have a query that has TECH_ID, SEQ_NBR, and PELL_FT_AWD_AMT
SELECT ISRS_V_NEED_ANAL_RESULT_PARENT.TECH_ID,…