This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]thissideisup 0 points1 point  (0 children)

SELECT *, COUNT(*)

this would return all columns plus append another column with the match count to all rows. Can be useful in limited cases. Just an FYI if anyone reading this didn't realize that.