In Sql server 2005 select col + '('+ cast (count(col)as varcha

if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..

1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..

Question Posted / rakesh prasad

17 Answers
19662 Views
3i Infotech, Rolta, TCS, I also Faced
E-Mail Answers

Answer Posted / rakesh prasad

In Sql server 2005

select col + '('+ cast (count(col)as varchar(1000))+')'from
tablename group by col

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sqlservr.exe - process - sql server (sqlex?press)?

1151

What is RAID? What are the different types of RAID configurations?

1178

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1059

A trigger can reference objects outside the current database? State true or false.

1060

How to use values from other tables in update statements in ms sql server?

1178

What are the advantages of mirroring?

1041

What is partition, how will you implement it? : sql server analysis services, ssas

1097

Explain what role entity and relationship play in an ER diagram.

1111

What are different backups available in sql server?

1152

How to write a query with a left outer join in ms sql server?

1026

How do I view a procedure in sql server?

1036

What is a raid and what are different types of raid configurations?

1321

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

980

What are the types of database schema? : sql server analysis services, ssas

1184

What is the process of normalization?

1178