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
- 19168 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
What is the difference between primary key and unique constraints?
What is resource db in sql server?
List the types of recovery model available in sql server?
How to start sql server browser service?
What is cursors? And what are the different types of cursor?
What programming language would you use to create embedded functions in ssrs?
Will the writetext statement activate a trigger?
What is report snapshot in ssrs?
What is sql language?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Can you import Microsoft Excel data to SSRS?
If we delete pack Spec what will be the status of pack Body ?
Can group by and orderby be used together?
Using the customer, and order table in northwind database, please write a query to produce xml?
your distribution database is full what will u do
