The Difference between 'Count' and 'Count(*)'

Answer Posted / t.lakshmi

count - It returns the non null values
count(*) - It returns the null values and duplicate values

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain can you implement data mining in ssrs?

122


what's the information that can be stored inside a bit column? : Sql server database administration

771


What is log cache in sql server?

766


What is sql stored procedure?

831


How can you ensure that the database and sql server based application perform well?

840


What is lock escalation? : sql server database administration

878


How do I start sql server 2016?

714


How do I partition a table in sql server?

758


Write an sql query for deleting duplicate rows?

776


What is rolap and its advantage? : sql server analysis services, ssas

1005


When is the use of update_statistics command?

780


Write the queries for commands like Create Table, Delete table, Drop Table etc.

809


How to add an address record into adventureworkslt?

786


What's new in sql management studio for sql server? : sql server management studio

806


Explain transaction server distributed transaction?

723