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
- 19705 Views
- 3i Infotech, Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / praveen singh
create table #temp1(id int)
insert into #temp1 values(4)
declare @str nvarchar(500)
select @str=''
select @str =@str+ id from (select cast(id as varchar) +'('+
cast(count(id) as varchar(22))+ ')' id from #temp1 group
by id) t
select @str
output will be :1(5)2(1)3(2)4(1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how to control the amount of free space in your index pages? : Sql server database administration
What are the advantages of partitioning?
Explain external key management in sql server 2008
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to use order by with union operators in ms sql server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How do I edit a stored procedure in sql server?
How to verify a login name with sqlcmd tool?
Which language is supported by sql server?
What is cdc in sql server?
What is difference between oltp and olap?
What are the methods used to protect against sql injection attack?
How do I install sql server?
Why do you need a sql server?
how many type of indexing in database?
