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..
- 17 Answers
- 16376 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
What are sql servers used for?
What is the difference between value type and reference type?
What is the difference between function and stored procedure in sql server?
What is the stuff and how does it differ from the replace function?
What is multi-statement table-value user-defined function?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How efficient you are in oracle and SQL server?
Why are sql functions used?
What are the types of ssrs?
What are the advantages to use stored procedures?
What do you know about normalization and de- normalization?
How to find table changes in sql server?
Which is the latest version of sql server and when it is released?
What is a result set object returned by odbc_exec()?
Is it ok to shrink transaction log?
