JElster
asked on
Help with SQL - Return 1 complete record for each group
Hi..
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...
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...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx