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

What is apply operator in sql?

570


How can you append an identity column to a temporary table?

453


How you can get a list of all the table constraints in a database?

529


What are the pre-defined functions in the sql server?

532


explain declarative management framework (dmf) in sql server 2008?

599






What is lookup override?

592


What is a not null constraint?

603


What is mean by candidate key?

558


How to link tables in sql server?

483


How to modify the underlying query of an existing view?

545


What is difference in performance between insert top (n) into table and using top with insert?

543


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

609


How to create a scrollable cursor with the scroll option?

506


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

564


What is parameterized reports in ssrs ?

105