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
- 18612 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
What is rs.exe utility?
Why use sub query in sql server and list out types of sub queries?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What are the acid properties?
How to add an address record into adventureworkslt?
How many types of objects are there?
How to fine-tune reports?
What is the meaning of sql server?
What are the types of lock supported by ?
What are the authentication modes in sql server? How can it be changed?
Where actually sql azure database is hosted?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Is port 1433 secure?
What is dimension table? : sql server analysis services, ssas
What is the purpose of sql profiler in sql server? : sql server database administration
