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

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

can any body tell me how to know the password of current user in sql server

1825


Define views.

780


How to Sync Two SQL Azure Databases?

111


Are null values the same as that of zero or a blank space?

817


What is difference between index and primary key?

858


What are Row versions of DataRow?

824


Is it possible to replicate data from sql server to oracle? : sql server replication

797


What is an indice?

797


How to choose all records from the table?

833


how we use window authentication connection with sql server.?

856


Relational calculus is what type of language?

809


How to encrypt data between dialogs?

802


How many columns can we include on clustered index ?

717


Where is localdb stored?

764


What are the different kinds of ssrs reports?

192