Resolved: difference between 2 codes
Select count(salary)
from salaries
where salary >= 100000
is similar to
Select count(*)
from salaries
where salary >= 100000
?
1 answers ( 1 marked as helpful)
Hi Fatma!
Thanks for reaching out.
Yes, both codes give the same result set. Since there are no NULL
values, it does not matter what column you will provide to the COUNT()
function.
Hope this helps.
Best,
Tsvetelin