I have the table like this, then i display the each field with count like fig.2
sql query with count
I have the table like this, then i display the each field with count like fig.2Loading
I have the table like this, then i display the each field with count like fig.21 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jan 22, 2013, 4:34 AM
You figured showing some odd requirement. Please elaborate it. from figure we can judge your excat requirement.
By the way you can get count, by using following query.
select cast(Age as varchar) + ':' + cast(COUNT(*) as varchar) from #temp
group by Age
please replace #temp with original table name.