select SNo, '(' + convert(varchar,count(SNo)) + ')' fr

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 / rajkumar v

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

Answer Posted / rajkumar v

select SNo, '(' + convert(varchar,count(SNo)) + ')' from
test group by SNo having COUNT(*)>=1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does a profiler work?

993

What is nonclustered index with included columns ?

1014

What are the diifferences between the ms sql server vs mysql?

1234

What are the new features of sql server 2008 r2 reporting service?

212

What is 3nf normalization?

1048

How to defragment table indexes?

1036

how would you troubleshoot blocking? : Sql server database administration

1025

What are the commands used in DCL?

1082

Tell me what do you understand by a view? What does the with check option clause for a view do?

1059

How to create a new login name in ms sql server?

1106

What will be the maximum number of indexes per table?

1016

How do I find the sql server instance name?

1012

What is RMS migrations?

2189

How many types of database relationship in sql server?

1100

what are different types of backups available in sql server? : Sql server database administration

982