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
- 18477 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / manju
select key,count(key)as"count of items" from tablename
group by key order by key
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you force a query to use a specific index?
What is the tcp/ip port on which sql server runs?
What is 4nf in normalization form?
Explain how many types of relationship?
What is etl - extraction, transformation, and loading?
What is data compression?
Can primary key be null?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is difference between rownum and rowid?
How do I run a trace in sql server?
What is global temp table?
How to create a new schema in a database?
How to return the top 5 rows from a select query in ms sql server?
What is the difference between osql and query analyzer?
What are different types of table joins?
