32 C
Chennai, India
Friday, April 9, 2021 05:26 AM
Oracle Database

Oracle Database

Hi,

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;

 

And

 

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

Articles

Blogs

Tips