Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Friday, June 28, 2019

Difference between count(*) and count(col)

select count(*) from hrtable;
select count(name) from hrtable;

count(*),operation counts all rows in the table, regardless of the values in the rows.
count(name), the count operation counts all rows where “name” is not NULL.

No comments:

Post a Comment