Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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..

Question Posted / sandy

Answers were Sorted based on User's Feedback



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..

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

Is This Answer Correct ?    0 Yes 0 No

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..

Answer / rajkumar v

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

Is This Answer Correct ?    0 Yes 0 No

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..

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

Is This Answer Correct ?    0 Yes 0 No

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..

Answer / rajkumar.v

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

Is This Answer Correct ?    0 Yes 0 No

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..

Answer / javamaster

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

Is This Answer Correct ?    0 Yes 0 No

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..

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)

Is This Answer Correct ?    0 Yes 1 No

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..

Answer / sagar more

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is 3nf normalization form?

0 Answers  

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

What the difference between UNION and UNIONALL?

0 Answers   HCL,

What is the disadvantages of index?

3 Answers   TCS,

What is t-sql script to take database offline – take database online.

0 Answers  

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  

Why we need a group by clause?

4 Answers  

what are the problems in logshipping?

3 Answers  

How adventureworkslt tables are related?

0 Answers  

Do you know what is normalization of database? What are its benefits?

0 Answers  

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

For more SQL Server Interview Questions Click Here
Categories