In SQL Server 2000, Query: ------ select count from employees Answer:

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

Question Posted / selvaraj.v

13 Answers
28752 Views
I also Faced
E-Mail Answers

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

Which is the main third-party tool used in sql server?

942

What the different types of Replication and why are they used?

1071

How do I view views in sql server?

1006

What is the fillfactor concept in indexes?

985

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1036

Explain the difference between HTTP and HTTPS in database?

1036

What are the new features are introduced in sql server 2012 reporting services?

149

Explain index in sql server?

1013

What are “unrepeatable reads”?

1234

what is the difference between count(*) and count(1) ?

1085

Where do you find the default Index fill factor and how to change it?

1063

What is indexed view? How to create it?

1009

What are distributed partitioned views?

1076

What are the components of sql server service broker?

1016

What are the different types of backups avaialabe in sql server 2005?

1021