SELECT SUM(case when col1='a' then 1 else 0 end) a

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

11 Answers
15440 Views
I also Faced
E-Mail Answers

Answer Posted / sankarapandian

SELECT SUM(case when col1='a' then 1 else 0 end) a_count,
SUM(case when col1='b' then 1 else 0 end)
b_count,
sum(case when col1!='a' and col1!='b' then 1
else 0 end)other_count
FROM t1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between sga and pga.

1160

What are the two types of cursors in pl sql?

1073

what are the t string functions available in tsql? : Transact sql

1002

What are the two different parts of the pl/sql packages?

1081

What are the advantages of stored procedure?

1003

What is nvarchar in sql?

924

How much ram can sql express use?

980

How do I find duplicates in sql?

929

What is auto increment in sql?

1116

Why we use triggers in mysql?

990

Is drop table faster than truncate?

985

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

996

What is a temporal data type?

1044

What are the usages of sql?

1056

What is pls_integer in pl sql?

1100