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
- 16708 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 you can find out if an index is useful to the optimizer?
How do I view a stored procedure in sql server query?
What are recommended options to be used while using db mirroring? : sql server database administration
How to stop a loop early with break statements in ms sql server?
Explain different types of self contained sub query?
What are system databases into sql server (2005/2008)?
What is similarity and difference between truncate and delete in sql?
How many replicas are maintained for each sql azure db?
What is efficiency data?
How do you migrate data from mssql server to azure?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How do you test your database? : sql server database administration
What do you mean by normalisation?
 Explain what is sql override for a source taLle in a mapping?
What are logical database components? : SQL Server Architecture
