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
- 18470 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 global temp table?
how to do partition in sqlserver
What is the use of =,==,=== operators?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to disable stored procedure sql server?
What is self contained multi valued query?
How to test subquery results with the exists operator?
Explain what is row_number function?
What are the two modes of authentication in sql server?
Please explain what is “asynchronous” communication in sql server service broker?
What are the key configuration files for sql server reporting services ?
What is normalization and denormalization in sql server?
Explain how to maintain a fill factor in existing indexes?
What is bookmark link in ssrs?
what is a self join? : Sql server database administration
