Answer Posted / vijay dev saxena
Count(expr) -> returns the number of records in the table
where the expr is not null in the particular column.
Count(*) -> returns the number of all records in the table.
(including duplicates and those with nulls)
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is NOT NULL Constraint in sql server 2012?
How to connect to a sql server using odbc_connect()?
Explain about Normalization?
What is set nocount on?
Difference between Logical Page and Physical Page in SSRS.
What is measure group, measure? : sql server analysis services, ssas
What is database replication? What are the different types of replication you can set up in sql server?
How to create a view with data from multiple tables?
What are different types of statements that are supported by sql?
What is db stored procedure?
How will you decide the active and passive nodes?
How to disconnect from a sql server using mssql_close()?
How to copy the tables, schema and views from one sql server to another?
What is a domain constraint give an example?
What is scan table/view and seek table/view when its occurs? : sql server database administration