Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 19722 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
select key,count(key1) from [table_name]
group by key
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are some examples of schemas?
What are “lost updates”?
How to transfer a table from one schema to another?
Does sql server 2000 clustering support load balancing?
Explain SSRS Architecture?
How to find out the list schema name and table name for the database?
What are trace flags and mention a few common trace flags used with sql server?
What is policy management?
How many tables can be joined in SQL Server?
What information is maintained within the msdb database?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Explain what is cte (common table expression)?
What are drilldown reports?
What are the steps to insert a table?
when you create a database how is it stored? : Sql server database administration
