SELECT SUM(DECODE(txt,'a',1)) a_count, SUM(DECODE(txt,'b�

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 / vivek nagarajan

11 Answers
15869 Views
I also Faced
E-Mail Answers

Answer Posted / vivek nagarajan

SELECT SUM(DECODE(txt,'a',1)) a_count,
SUM(DECODE(txt,'b',1)) b_count,
SUM(DECODE(txt,'a',0,'b',0,1)) others_count
FROM t1;

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does data normalization mean?

1028

What is the best free sql database?

1104

Does mysql_real_escape_string prevent sql injection?

995

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1117

What is multiple columns?

1120

What is relationship? How many types of relationship are there?

1265

How to add new employee details in an employee_details table with the following details

1138

How do I view stored procedures?

1023

Why is sharding used?

1064

Can a procedure in a package be overloaded?

1103

What is rownum?

1034

What is the difference between sum and count in sql?

1039

What does where 1 1 mean in sql?

1079

What is union?

1253

How do you run a query?

1051