Answer Posted / vijay dev saxena
Count(exp): Counts the number of rows excluding null values.
Count(*) : Counts the number of rows including null and
duplicates records.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is bulkcopy in sql?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How do you test your database? : sql server database administration
What is the New in SQL server 2008?
How the authentication mode can be changed?
Can we delete data from a view?
Explain syntax for viewing, dropping and disabling triggers?
What language is sql server written in?
How to add more data to the testing table in ms sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is snapshot replication?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is primary key and example?