Query for column wise data count including the NULL record ?

Replies to This Discussion

Permalink Reply by shruti chaudhary on June 20, 2013 at 11:15am

select columnA, count(*) from table group by columnA.

Hope this is what you were looking for

• ▶ Reply

Permalink Reply by sugat misra on August 16, 2013 at 3:11pm

As per my knowledge there is no other way to do it other than adding one identity column and then performing count operations on that new column.

Query will be:
alter table tablename
add columnname int identity(1,1)

select Count(columnname) from tablename

• ▶ Reply

Permalink Reply by Murari on October 6, 2013 at 12:08am

sugat is right..

• ▶ Reply

Permalink Reply by kabir on October 7, 2013 at 11:34am

try this one select  count(Firstname) from [dbo].[User]

• ▶ Reply