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
15868 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

Why we use triggers in mysql?

1041

Explain the the delete statements in sql?

1117

How to revise and re-run the last sql command?

1219

what is error ora-03113: end-of-file on communication channel?

1230

What is difference between stored procedure and trigger?

1252

Define commit, rollback and savepoint?

1082

what are date and time intervals? : Sql dba

1105

What is native sql query?

1076

Why are cursors used?

1179

Can we join more than 2 tables in sql?

1094

Give the order of sql select?

1187

How many sectors are in a partition?

1120

Does pl/sql support create command?

1168

What are analytic functions in sql?

1074

what is a database lock ? : Sql dba

1227