Quality is delighting customers
select columnA, count(*) from table group by columnA.
Hope this is what you were looking for
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
sugat is right..
try this one select count(Firstname) from [dbo].[User]