select convert(varchar,key) + '('+ convert(varchar, count(key))

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 / pradip jain

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

Answer Posted / pradip jain

select convert(varchar,key) + '('+ convert(varchar,
count(key))+')' from table_name group by key

Hanamesh, why top 20?

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are the restrictions while creating batches in sql server?

1114

How to remove duplicate rows from table except one?

1063

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1043

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1104

What are statistics?

1050

What is the difference between left and right outer join?

1113

How do you check sql server is up and running?

1051

how can a database be repaired? : Sql server administration

1017

What do I need to start working with sql studio? : sql server management studio

1161

What are the types of table?

1029

What are the database roles? : sql server security

1277

What is rs.exe utility?

164

What is the new security features added in sql server 2014? : sql server security

1049

What are the new scripting capabilities of ssms? : sql server management studio

1119

Explain what are the events recorded in a transaction log?

1051