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
How to create new tables with "select ... Into" statements in ms sql server?
what are defaults? : Sql server database administration
What are different types of constraints?
what's new in sql server 2016?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is a partition key?
Will sql server 2005 allow you to reduce the size of a column?
What is the full meaning of dml?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain how you can configure a running aggregate in SSRS?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is the use of commit?
Explain how you can deploy an SSRS report?
What are the different types of join?
Is null vs coalesce?