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
- 19060 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna reddy l
select convert(varchar(5),ex)+'('+convert(varchar(5),count
(ex))+')' from example group by ex
Table name example and columna name ex
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between SQL notification and SQL invalidation?
What is meant by Active-Passive and Active-Active clustering setup?
What is log in sql server?
How to make conditional sum in ssrs?
What is repeatable read?
When cursors are useful?
Explain the working of sql privileges?
How many databases instances are there in sql server 2000?
Can you explain what is indexed view? How to create it?
How to bind a view to the schema of the underlying tables?
What are the restraints imposed on the table design by a merge replication?
Do you know what are the ways available in sql server to execute sql statements?
What is report snapshot in ssrs?
Explain what are the events recorded in a transaction log?
Define normalisation?
