Skip to main content

You are here

How does SQL statement COUNT(*) differ from COUNT(1)

Submitted by dracula on Fri, 2012-07-13 10:53
dracula's picture

How does SQL statement COUNT(*) differ from COUNT(1). I heard there are difference in terms of performance. I was asked this question recently in an interview.

Author Information

dracula
dracula's picture
Offline
Last seen: 2 years 9 months ago
Joined: 2012-06-15 19:00

Recent comments

Where did Ebola virus come from?

Are Africans the only ones who ate "dirty" meat?

2 years 9 months ago
Where did Ebola virus come from?

Ebola came from primates like apes. It got into humans via eating unsterile meat. Particularly in Africa where the practice of eating "bush meat"...2 years 9 months ago

What jobs need knowledge of computer programming?

You have mentioned mostly core coding related jobs. What about:

  1. Business Analyst
  2. Project manager (IT)
  3. Software...2 years 9 months ago
Premium Drupal Themes by Adaptivethemes