I am new to Oracle. I have a doubt regarding two basic queries I see everyday at work. Say, I have a table employee with 1000 records. When I fire:
Select count(*) from employee;
Select count(1) from employee;
They both give me the same result – 1000.
Is there any difference between count(*) and count(1)?
- 1573 views
- 5 answers
- 10 votes