I would like to make a select statement, using a select distinct, and include a count in each record returned.
For example, for the dataset below, I would like the record to return only 1 instance of the "order number" and a count of how many different ones there are.
Can someone help with this? Thank you.
I would like the return to show this, from the dataset below it.
Order Number | Count
ID | Order Number