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
19703 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 are the methods used to protect against sql injection attack?

1119

What is open database communication (odbc)?

1115

What is sql stored procedure?

1147

Why would you call update statistics?

1072

Define left outer join?

1027

Explain following error properties?

1060

Why do we use non clustered index?

1132

Can we add our custom code in ssis?

1040

What is the difference between locking and multi-versioning?

1040

Â Explain what is sql override for a source taLle in a mapping?

1057

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2137

What is a primary key?

998

What are the rendering extensions of ssrs?

160

What is tempdb in sql server?

1029

What is sql sandbox in sql server?

1297