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
18958 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 can i Relate Tables in SSIS

1065

What is query optimization process?

989

How to turn on the mssql api module in php?

1055

Will the writetext statement activate a trigger?

1064

Explain the types of indexes.

1182

Define inner join in sql server joins?

1041

What is a sql join?

998

How to fetch the next row from a cursor with a "fetch" statement?

1056

What is right outer join in sql server joins?

1158

How to create “dependant” parameter “make, model, year”

129

what is a join and explain different types of joins? : Sql server database administration

940

What is an execution plan? When would you use it?

957

What is difference between aggregate and analytic function?

906

Explain different types of collation sensitivity?

963

What are the components of sql server service broker?

994