I need to return 1 record , a sample record for each state in a table. Table has millions of records.
Table as a state field.
I need 1 single record for each state with all the fields..
table looks something like this
name, address, city, STATE, field1, field2, field3...