Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

The Difference between 'Count' and 'Count(*)'

Question Posted / selvaraj.v

Answer Posted / selvaraj.v

In SQL Server 2000,
Query:
------
select count from employees
Answer:
------
invalid column name 'count'


In SQL Server 2000,
Query:
------
select count(*) from employees

Answer:
-------
No column name
----------------
1. 20

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you create type- insensitive operator?

809

Explain where clause?

799

What are ddl (data definition language) statements for tables in ms sql server?

850

How to find the login name linked to a given user name?

736

What is the template in sql?

785

What are different types of database indexes?

757

how to avoid cursors? : Sql server database administration

719

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

756

What is Federation and Federation Member?

90

 Explain what is sql override for a source taLle in a mapping?

814

What is the full form of ddl?

723

What is read uncmmited?

848

What is a select query statement in ms sql server?

829

What are the advantages of policy management?

806

Mention the differences between having and where clause.

856