Answer / 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

Answer / rajkumar v

select SNo, '(' + convert(varchar,count(SNo)) + ')' from
test group by SNo having COUNT(*)>=1

Answer / madhu sudhan g

Hiiiii

Lets the table name is No1 having column A is of int data Type
Now the query is
select convert(nvarchar(5),A) + '(' +
convert(nvarchar(5),count(1))+')' from NO1 GROUP BY A

Answer / rajkumar.v

select convert(varchar,id) + '(' + CONVERT(varchar,count
(id)) + ')' as tot from tblname group by id

Answer / javamaster

select key,count(key) from tablename
group by key order by key

Answer / 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)

Answer / sagar more

select replace(wm_concat(key||''||'('||count(*)||')' ),',','') key from drop1
group by key

explain different types of jions with examples briefly?

3 Answers   Zensar,

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  

How do you simulate a deadlock for testing purposes

1 Answers  

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

Differentiate between sql temp table vs table variable?

0 Answers  

can you any body tell me the how to decrease the logfile

4 Answers  

What is best institute to Learn DotNET And SQL in chennai?

0 Answers  

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?

0 Answers   ABC,

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

What is the difference between referencing and joining?

1 Answers  

what is Covering Index ?

3 Answers   Thomson Reuters,

What are the new data types are introduced in sql 2000?

0 Answers