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
- 19183 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
What is a join in sql? What are the types of joins?
What is an execution plan?
What is the difference between a view and a stored procedure?
what is a transaction and what are acid properties? : Sql server database administration
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How do I start sql server?
Explain different types of self contained sub query?
How you can change the database name in SQL SERVER?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Relational calculus is what type of language?
How to create a view with data from multiple tables?
What is abstracting periodical?
What is rtm version in sql server?
Explain about remote stored procedure?
What is a not null constraint?
