select key,count(key1) from [table

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 / vikas kant

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

Answer Posted / vikas kant

select key,count(key1) from [table_name]
group by key

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why are sql functions used?

1062

How connect excel to sql server?

936

What does REVERT do in SQL Server 2005?

926

Mention a few common trace flags used with sql server?

893

What types of Joins are possible with Sql Server?

1075

What is #table in sql server?

1007

What is a trigger in sql server?

1105

In what three ways is the return statement used in a stored procedure?

968

Ms sql server index?

1023

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1009

What is sub-query in sql server? Explain its properties.

1049

How to create a login account in ms sql server to access the database engine using "create login" statements?

1076

What are the advantages of paper records?

914

How do I view a trc file?

907

What are the functions in sql server?

911