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.
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