Is it possible to create query which will report how many instances of a column values appear in the table?
Lets say I've a got a table with a column of states. I'd like to create a query that has a line for each state found in the table along with *how many* times it was found in the table.
Like
SELECT DISTINCT(statename)FROM states
would give me the name, but I also need to know how many times each state appears in the table.
Is this possible?
Lets say I've a got a table with a column of states. I'd like to create a query that has a line for each state found in the table along with *how many* times it was found in the table.
Like
SELECT DISTINCT(statename)FROM states
would give me the name, but I also need to know how many times each state appears in the table.
Is this possible?