If the column name is key select key,count(*) from jojo group by key s

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

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

Answer Posted / neeraj

If the column name is key
select key,count(*) from jojo
group by key

simple

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create new table with "create table" statements?

1192

What is field with example?

974

What is delete query?

990

What is self join in sql server joins?

1116

what is the difference between a primary key and a unique key? : Sql server database administration

1041

How much does sql server 2016 cost?

1157

What is the user of Primary key?

1029

Can you edit the .rdl code associated with a linked report?

168

What Are the Main Features of SQL Azure?

121

What is sql server programming?

1090

Differentiate between SQL and ORACLE joins and write their syntax.

1071

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1178

What is the bookmark lookup and rid lookup?

1034

How to disable triggers using "disable trigger"?

1104

What is a performance monitor?

1020