Hiiiii Lets the table name is No1 having column A is of int data Type

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 / madhu sudhan g

17 Answers
18982 Views
3i Infotech, Rolta, TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to connect sql server management studio express to sql server 2005 express?

1015

What is normalization? Explain its different types?

1075

What is instead of trigger sql server?

984

Tell me the use of keyword with encryption. Create a store procedure with encryption?

991

how to use DTS package in 2000,2005,2008 in sql server

1821

Explain filestream storage of sql server 2008?

988

What is pivot and unpivot?

998

Is the primary key column of a table an index in ms sql server?

947

What is tempdb database? : SQL Server Architecture

1168

What is cube dimension? : sql server analysis services, ssas

991

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1086

What is NOT NULL Constraint in sql server 2012?

979

What is the tcp/ip port on which sql server runs?

1132

Does transparent data encryption provide encryption when transmitting data across the network?

1022

What is a virtual table in sql?

979