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..
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 is transaction server implicit?
What is partitioned view?
When I run the sql server 2000 setup, it just hangs. What do I do?
what are the disadvantages of cursors? : Sql server database administration
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How to create a local temporary stored procedure?
What sql server means?
write an SQL query to list the employees who joined in the month of January?
Do I need a report server to run reports in my application?
What is best institute to Learn DotNET And SQL in chennai?
Define outer join?
What is the downside of using udf?
How you can change the database name in SQL SERVER?
What command would you use to add a column to a table in sql server?
What is a transact-sql statement?