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
18938 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 are the types of user defined functions in sql server?

1034

Explain what is cte (common table expression)?

1111

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1117

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1112

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2725

List down some advantages of sql stored procedure?

945

What is de-normalization in sql database administration? Give examples?

960

How do you identify a foreign key?

1007

How to convert numeric expression data types by assignment operations?

1051

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

961

where the connection string store in the database

2050

How much is a sql server license?

932

What is sql server profiler?

983

What is database replication? What are the different types of replication you can set up in sql server?

945

What is difference between inner join and full join?

1042