General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I need to run an SQL SELECT to do a histogram.... for example, the number of orders in each state:
NJ 456
AZ 2212
CA 12
MN 334
I know the SQL involves the DISTINCT option and the COUNT( ) function... can't seem to find the example I had from a few years ago... can anyone help?
Thanks!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only