So I need to find an individual rank for a record
I have these results
EmpTot, JOIN_NUMBER, RANKRESULT, STATE
- 524, 21056, 1, WI
- 523, 20973, 2, WI
- 477, 21411, 3, WI
- 460, 20714, 4, WI
- 394, 20974, 5, WI
- plus a hundred more
I just want to have the result be one record, where the join_number is.. lets say: 20714 (rank 4) and show 460, 20714, 4
I found some sql with the find_in_set, but it didn't exist in my version, so I am stumped. Right now, this is all I have that works.
SELECT JOIN_NUMBER, thestate, EmpTot, RANK() OVER (PARTITION BY thestate ORDER BY EmpTot DESC) AS RankResult FROM thistable WHERE State = 'wi'