Select by attribute then exporting selection

[NathanBaylot1]

arcpy.TableToTable_conversion("Master_TAHI", "C:\\Users\\D2148\\Documents\\Maps\\Parish Roads\\TAHI_LRS\\Parish_roads\\TAHI_parish\\FIPS", "FIPS001", "\"FIPS PARIS\" = '001'")

I am trying to select by attributes in a .dbf table then export it out to a new .dbf with the selected features only. I am having a problem executing this file. It keeps saying there is a error. The maximum record length has been exceeded. The file only has 87000 records.

Also, once this is figured out. How do I continue to go to the next select by attribute using a while statement. I need it to go to the FIPS PARIS = 127 and each FIPS is odd starting with 001 (eg. 001,003,005...)

If the table to table way doesn't work, any suggestions would be helpful. Thanks.

[ChrisSnyder]

How can i represend in arcmap the value max?

Use the SummaryStatistics tool: http://resources.arcgis.com/en/help/main/10.1/index.html#//00080000001z000000

[sofiatavantzi]

Hello ! i have an easy question, i think, but i can not find the answer.
I want to find the max value of a column, the question is 'which district has the most students?'
how can i represend that in an attribute query? in arcmap?
I have this columns, District, Schools per district, Name of school, students.

thanks
sofia