sql server table

try this ....

create database demo
use demo
create table tabs(id int,chr char(1))

insert into tabs values('1','x')
insert into tabs values('2','x')
insert into tabs values('3','x')
insert into tabs values('4','y')
insert into tabs values('5','y')
insert into tabs values('6','z')

select * from tabs

select (cast(count(chr) as char)+chr) as result from tabs group by chr

output

result
------------
3x
2y
1z

hi Joseph,
Follow Santosh Kumar query... perfect


for more details about cast-convert in sql.
http://msdn.microsoft.com/en-us/library/ms187928.aspx

select Cast(COUNT(1) as varchar)+ valued from tbl group by field

Here is my sample demo
create table test(
id int,
valued varchar(2))



insert into test values(1,'x')
insert into test values(2,'x')
insert into test values(3,'x')
insert into test values(4,'y')

select Cast(COUNT(1) as varchar)+ valued from test group by valued:


output-
3x,
1y