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

How would you reference column values before and after you have inserted and deleted triggers?

1021

what is schema? : Sql dba

987

How can I see all tables in sql?

990

Is subquery faster than join?

953

Can %notfound return null after a fetch?

1005

What operating systems are supported by oracle sql developer?

904

What is dense_rank?

879

How is debugging done?

921

When to use inner join and left join?

906

What is the purpose of the partition table?

1003

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1099

Explain what is rdbms?

993

What is t sql used for?

974

What is sqlservr exe?

943

How do I run a program in pl sql?

952