Answer Posted / pradip jain
COUNT(column_name): COUNT THE NUMBER OF ROWS EXCLUDING NULL
VALUES BUT INCLUDING DUPLICATES
COUNT(*):COUNT THE NUMBER OF ROWS INCLUDING NULL VALUES AND
DUPLICATES.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between varchar and nvarchar?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Explain transaction server distributed transaction?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How are the exceptions handled in sql server programming?
What are the rendering extensions of ssrs?
what stored procedure can you use to display the current processes? : Sql server administration
Do you know query execution plan?
What is a trigger in sql server?
How to call a function from a stored procedure in SQL Server ?
Do you know the cursor types?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How do I partition a table in sql server?
What is the contrast between sql and pl/sql?
Can a table be moved to different filegroup?