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

Explain the cursor lock types?

1099

How do I find sql server instance name?

1008

What is difference between rollback immediate and with no_wait during alter database?

1133

How to create an identity column?

1301

Explain transaction server auto commit?

1090

What information is maintained within the msdb database?

1022

Explain relational data?

969

Do you know nested transaction?

1002

Why should one not prefix user stored procedures with ‘sp_’?

1099

How many types of stored procedures are there in sql server?

1057

How to grant a permission in ms sql server using "grant execute" statements?

1136

What type of locking occurs during the snapshot generation? : sql server replication

1375

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1027

What are relationships and mention different types of relationships in the dbms

1011

How to recreate an existing index in ms sql server?

1116