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 is a live lock? : Sql server database administration
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is the use of keyword with encryption. Create a store procedure with encryption?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Why I am getting this error when dropping a database in ms sql server?
How do I find the sql server instance name?
Why we use trigger in sql server with example?
How many tables can be joined in SQL Server?
How to delete exactly duplicate records from a table?
Mention what are the different types of ssrs reports?
What do you understand by a view?
How can you control the amount of free space in your index pages?
What are the main differences between #temp tables and @table variables and which one is preferred?
In how many ways you can invoke ssrs reports?
Can binary strings be converted into numeric or float data types?
