select col1,count(*)cnt from T1 group by col1

Table name: T1, it has only one column.

col1
------
c
b
a
b
b
b
b
d
s
a
a
t
s

Requirement:

I need the following output from the above base table by
using SQL query.

col1 Cnt
----- -------
a 3
b 5
Others 5

Please help.

Thanks
Guru
v.gurus@in.com

Question Posted / manas

11 Answers
15866 Views
I also Faced
E-Mail Answers

Answer Posted / manas

select col1,count(*)cnt from T1 group by col1

Is This Answer Correct ?

8 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of count (*) in sql?

1119

What is difference between sql and excel?

1184

what are numeric data types? : Sql dba

1111

What is difference between stored function and application function?

1291

What is rollback?

1187

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2140

What is normalization in sql?

1067

what are the different type of normalization? : Sql dba

1073

What is data modelling in sql?

1077

What are aggregate functions in sql?

1225

What is difference between cursor and trigger?

1129

How many types of cursors supported in pl/sql?

1260

Is sql better than access?

1071

What are the types of sql commands?

1162

what is myisam? : Sql dba

1163