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

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

1074

What is the difference between for xml raw and for xml auto?

1028

What is difference in performance between insert top (n) into table and using top with insert?

1038

What is the difference between an index and a unique index?

996

Explain the cursor lock types?

1047

What are different types of schemas?

942

Explain full-text indexing?

972

Define magic tables in sql server?

1050

What is sqlcmd?

1043

Name few of the dcl commands in sql?

1003

Do you know how to store and query spatial data?

1036

What is partition in sql server?

1035

What is sharding?

116

How to list all schemas in a database?

1053

What is the sql profiler?

936