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 11 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 11 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 11 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 11 months ago
Premium Drupal Themes by Adaptivethemes