What is differrent between count(*) and count(1)
Hi ,
What is the difference between count(*) , count(1)
select count(*) from emp
output is : 14
select count(1) from emp
output is : 14
select count(7) from emp -- here 7 th column is comm column
output is : 14
Any difference?
What is the difference between count(*) , count(1)
select count(*) from emp
output is : 14
select count(1) from emp
output is : 14
select count(7) from emp -- here 7 th column is comm column
output is : 14
Any difference?
0