select key,count(key) from tablename group by key order by key

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

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

Answer Posted / javamaster

select key,count(key) 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 is a matrix in ssrs?

135

What are the properties of sub-query?

1027

how to control the amount of free space in your index pages? : Sql server database administration

985

What are drilldown reports?

140

Tell me what is the order in which the sql query is executed?

900

what is a transaction and what are acid properties? : Sql server database administration

966

How to store and query spatial data?

937

What is the difference between TRUNCATE and DROP?

1067

How do I setup a local sql server database?

948

Explain system functions or built-in functions? What are different types of system functions?

917

How do triggers work?

882

How many databases can we create in a single server?

205

What is db stored procedure?

816

Explain primary key and foreign key constraints?

966

What is the name of the Database which IBM mainframe uses?

949