SQL Query - Need some basic help
- by Chuck Folds
I'm in need of some basic TSQL help. Here's my table layout:
Orders Table
SSN
ZipCode
ZipLookup Table
ZipCode
State
All columns are varchars.
How would I get a list of States with the number of distinct SSN's in each state? Preferably, if a particular SSN has orders from multiple states only the state with the most orders would be counted for that SSN.
Thank you for any tips you can give me.