3 edited tags
| link
2 added tags
| link

What is the difference between select count(*) and select count(any_non_null_colany_non_null_column)?

    Tweeted twitter.com/#!/StackDBAs/status/65739672504111104
1
source | link

What is the difference between select count(*) and select count(any_non_null_col)?

I seem to remember that (on Oracle) there is a difference between uttering select count(*) from any_table and select count(any_non_null_column) from any_table.

What are the differences between these two statements, if any?