Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / harish sharma
Count(column_name) returns the number of records in the
table where the column value is not null for the particular
column.
Count(*) returns the number of all records in the table.
(including duplicates and those with nulls)
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is implicit cursors?
What is BCP? When does it used in sql server 2012?
What is difference between global temporary tables and local temporary tables?
How to return the top 5 rows from a select query in ms sql server?
What is the importance of three tier architecture?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What are triggers? How do you invoke a trigger on demand?
What are the parts of a function?
What does COMMIT command do?
What is the correct order of the logical query processing phases?
What are the advantages of the mirroring?
How to generate random numbers with the rand() function in ms sql server?
What does normalization do to data?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is data set in report?
