Articles by Dennis Ålund (Tip/Trick: 1)

Tip/Trick: 1

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 0.00

Programming Languages

SQL

SQL COUNT(*) Vs COUNT(column_name) [Tip/Trick]

11 May 2010 Updated: 11 May 2010 Rating: 0.00/5 Votes: 0 Popularity: 0.00

Licence: CPOL Views: 6,140 Bookmarked: 3 Downloaded: 0

Well, another major point is that the two variants serve different purposes by definition. -- Count rows where 'column_name' is NOT NULLSELECT COUNT(column_name) FROM Table_Name-- Count ALL rows in Table_Name SELECT COUNT(*) FROM Table_Name-- ... which you just as well can...

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Dennis Ålund

Database Developer Oddbit

Indonesia

This member doesn't quite have enough reputation to be able to display their biography and homepage.