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
- 19747 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 are the components of dbms?
What is difference between cte and view?
What are the properties of sub-query?
What are the different editions available in sql server 2000?
What is the difference between osql and query analyzer?
What is your recommendation for a query running very slow? : sql server database administration
How to select true false based on column value in sql server?
What are policy management terms?
Explain what is meant by replication of database?
What is the difference between grant and with grant while giving permissions to the user?
What is the difference between ddl and dml?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Explain identity in sql server?
What is a full text index?
Do you know what is blocking?
