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
- 19719 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / rajkumar v
select SNo, '(' + convert(varchar,count(SNo)) + ')' from
test group by SNo having COUNT(*)>=1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I create a trace in sql server?
What is the use of commit?
What is the importance of concurrency control?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Can sql servers link to other servers like oracle?
What does COMMIT command do?
Explain difference between control flow and data flow?
What is the current pricing model of SQL Azure?
Do you know what is a linked server in sql server?
Explain various data region available in ssrs with their use?
What is truncate table?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the difference between a unique key and primary key?
Explain the concepts and capabilities of sql server?
Difference between Inner vs outer joins?
