Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sachin rathi
Count(column name or exp) returns the no. of records for a
specific/particular column of table excluding null values
whereas Count(*) returns all the rows/records in the table
including duplicated and null values
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what are the different ways to return the rowcount of a table?
What is 2nf normalization form?
Explain the difference between functions and stored procedures in sql server?
How to execute stored procedure and set temp table in sql server?
Explain hostprotectionattribute in sql server 2005?
What is index, cluster index and nonclustered index?
How do I open a .db file?
How can you insert null values in a column while inserting the data?
Are resultset updatable?
Explain transaction isolation levels in sql server?
what is datawarehouse?
How to search for a string in all stored procedure in sql server?
Explain steps of normalization?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How many types of cursor type are there?
