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

What is the difference between sql and t sql?

1049

when is the use of update_statistics command? : Sql dba

1058

What is cross join example?

1017

What can sql server reporting services do?

1120

Why are cursors used?

1125

what tools available for managing mysql server? : Sql dba

1093

What is trigger in sql and its types?

1076

What is sqlcontext?

1091

Why do we use function in pl sql?

1072

How many databases can sql express handle?

995

what are different types of collation sensitivity? : Sql dba

1081

Is sql pronounced sequel or sql?

1282

What is the purpose of primary key?

1043

What are the different types of dbms?

1023

What is a column in a table?

1137