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
15541 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 many tables can a sql database have?

982

Why are sql stored procedures used?

1060

What is rowtype?

1027

What is pl sql commands?

1049

What is the usage of the distinct keyword?

1221

What does plv msg allows you to do?

1148

Is join and inner join the same?

1010

Does inner join return duplicate rows?

991

Mention what are the benefits of pl/sql packages?

1086

What is implicit cursor in pl sql?

1097

What is trigger and types?

1030

What is crud stand for?

1004

What is clause?

1158

How to look at the current sql*plus system settings?

1157

What are the different types of tables in sql?

1010