What is the datatype returned by count(*)

Answer Posted / thirumal

count(*) returns the total number of not null values in
given column

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you know if the row fetched from cursor is still valid in underlying table?

760


What are the advantages of using stored procedures?

687


Define model database?

741


Difference between connected and disconnected database in .net with sql server?

772


Why do we need normalization?

663






How much is a sql server license?

692


What is meant by Active-Passive and Active-Active clustering setup?

749


Is it important for a database administrator to understand the operating system and file access?

727


how to create a scrollable cursor with the scroll option? : Sql server database administration

769


What is the default fill factor value?

761


Difference between primary key and clustered index?

686


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

781


What is bookmark link in ssrs?

145


Is natural join and equi join same?

707


What is a cache in ssrs?

121