Press the Any key to continue! (Software development and technology)
Monday, June 01, 2015
SQL – Getting the record counts of each distinct value from a table column
SELECT column_name, COUNT(column_name) as RecordCount
FROM table_name
WHERE (whatever criteria)
GROUP BY column_name
ORDER BY column_name
Blogged to help me remember and memorize!
No comments:
Post a Comment
Hi spammers! No need to waste your time here; comments are heavily moderated, so if you like, you can save us both a little time and just move on to the next site. :-)
For everyone else: Thanks for visiting! Your comments are more than welcome!
Posts
No comments:
Post a Comment
Hi spammers! No need to waste your time here; comments are heavily moderated, so if you like, you can save us both a little time and just move on to the next site. :-)
For everyone else: Thanks for visiting! Your comments are more than welcome!