Feed
Pro
Search

Author

Write
Drafts

Bug0 - The AI-native e2e QA regression testing Passmark - The open-source AI framework for regression testing Hackathons Changelog Brand Hashnode gql skill - let your AI agent publish to your Hashnode blog @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap
Sign in

Search Hashnode

Search posts, tags, users, and pages

Discussion on "SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)" | Hashnode

FeedDiscussion

Bradley Schacht

Principal Program Manager at Microsoft

Sep 15, 2011

SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)

What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a lie, but the rest of this blog is not a lie, just to be clear. :) COUNT(*) – Number of records in the table regardless of NULL...

bradleyschacht.com2 min read

Responses

No responses yet.