Count of: Users, PostHistory, Comments, Posts, Votes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 'Users', format(count(*), 'N0') as [Count]
from Users
union
select 'Posts', format(count(*), 'N0') as Posts
from Posts
union
select 'PostHistory', format(count(*), 'N0') as PostHistory
from PostHistory
union 
select 'Votes', format(count(*), 'N0') 
from Votes
union
select 'Comments', format(count(*), 'N0') 
from Comments

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results