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
- 16337 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / neeraj
If the column name is key
select key,count(*) from jojo
group by key
simple
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to include date and time values in sql statements?
What is SQL Azure Fabric?
What is the purpose of the tempdb database?
Can we call future method from queueable?
Can you explain different types of joins?
What is the fillfactor concept in indexes?
How do I get to sql server configuration manager?
How will you add a dimension to cube? : sql server analysis services, ssas
What is a coalesce function?
Explain how does the report manager work in ssrs?
What do you understand by mirroring?
What does null mean?
What new data source types were added in ssrs 2014?
What is auditing in sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?
