select key,count(key)as"count of items" from tablename group by

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 / manju

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

Answer Posted / manju

select key,count(key)as"count of items" from tablename
group by key order by key

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What happens to a trigger with multiple affected rows?

937

What is explicit mode in sql server?

1056

What are the instances when triggers are appropriate?

979

which table keeps the locking information? : Sql server administration

1075

Write the syntax for stuff function in an sql server?

1024

Why functions are used in sql server?

957

What does COMMIT command do?

1055

What is conditional split?

1060

Can you explain what is sql server english query?

992

What is trigger in salesforce?

975

What is Cross Join and in which scenario do we use Cross Join?

1011

Is mysql the same as sql server?

977

How do you size a resultset?

911

Does partitioning improve performance sql server?

974

What is clustered vs nonclustered index?

939