List every state in the United States and a zip code

There is a zip table containing all States and zip codes in the United States. How can I list a zip code for each state? There are two columns in each row, namely the State name and the zip code, which were not figured out for a long time. Later, we can see what others are doing. selectstate and max (zipcode) fromzipgroupbystategroupby are amazing, but it is difficult to use, mainly thinking

There is a zip table containing all States and zip codes in the United States. How can I list a zip code for each state? There are two columns in each row, namely the state name and zip code, which were not figured out for a long time. Later, let's see what others are doing. select state, max (zipcode) from zip group by state group by is wonderful, but it is difficult to use, mainly thinking

There is a zip table containing all States and zip codes in the United States. How can I list a zip code for each state?

Each row has two columns: the state name and zip code.

I did not think about it for a long time,

Later, let's see what others are doing,

Select state, max (zipcode) from zip group by state

Group by is wonderful, but it is difficult to use, mainly because it is too strange to think.