select convert(varchar(5),ex)+'('+convert(varchar(5),count (ex))

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 / krishna reddy l

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a covered index?

925

What is a result set object returned by mssql_query()?

1131

Explain the dirty pages?

985

What are policy management terms?

967

What security features are available for stored procedure?

1013

Does full backup break log chain?

947

What is raid and what are different types of raid levels?

1131

What is the return type of executeupdate ()?

887

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

961

How to write a query with an inner join in ms sql server?

1023

What is conditional split?

1044

What is sql server management studio? : sql server management studio

1063

What is a join in sql? What are the types of joins?

1073

What is transaction server consistency?

1023

What is data mart? : sql server analysis services, ssas

1036