select replace(wm_concat(key||''||'('||count(*)||'

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 / sagar more

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

Answer Posted / sagar more

select replace(wm_concat(key||''||'('||count(*)||')' ),',','') key from drop1
group by key

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is check constraint in sql server?

998

What are the default system databases in sql server 2000?

1024

Explain logical operators in sql server?

1105

How do you delete duplicate records in sql server?

1050

What is spatial and temporal data?

994

What are rows and columns?

1018

How can we improve performance by using SQL Server profiler?

1052

What were the latest updates to SQL Azure service?

111

How do I create a trace in sql server?

1037

Benefits of Stored Procedures?

963

Can I delete event logs?

921

What are the key configuration files for sql server reporting services ?

167

What is a covering index?

981

How you trouble shoot when any job fails

1932

What is difference between order by and group by?

1000