Displaying 1 result from an estimated 1 matches for "rankwithinst".
2007 Aug 31
3
by group problem
I am working with census data. My columns of interest are...
PercentOld - the percentage of people in each county that are over 65
County - the county in each state
State - the state in the US
There are about 3100 rows, with each row corresponding to a county within a state.
I want to return the top five "PercentOld" by state. But I want the County and the Value.
I tried