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
- 14483 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 value type and reference type?
What do you mean by tablesample?
what are the disadvantages of cursors? : Sql server database administration
How to add an address record into adventureworkslt?
What are the properties of the transactions?
What is the difference between for trigger and after trigger?
What is tabulation?
What are the disadvantages of primary key and foreign key in SQL?
what is an extended stored procedure? : Sql server database administration
how you can configure a running aggregate in SSRS?
What happens if you delete a table that is used by a view?
How to modify existing triggers using "alter trigger"?
How to convert character strings into numeric values?
How do I create a stored procedure in dbml?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
