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
19153 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

How raid can influence database performance?

1031

Define candidate key, alternate key, and composite key.

922

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1396

What are the purpose of Normalisation?

1050

How you can change a cross join into an inner join?

973

How many partitions a clustered index has by default in sql server 2012?

1089

Do you know exporting and importing utility?

1039

Can you please explain the difference between function and stored procedure?

1007

Why main is user defined function?

1011

Explain logical operators in sql server?

1108

What are the types of database recovery models?

1125

Explain ms sql server reporting services vs crystal reports?

916

Define indexes?

1043

Explain about integration services of Microsoft SQL server?

1032

What is SQL Azure Data sync?

121