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
15451 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 is the difference between count 1 and count (*) in a sql query?

987

How do you modify a table in sql?

1118

Explain what is rdbms?

1028

What does := mean in pl sql?

1041

What is the difference between microsoft access and sql server?

1054

what are sequences

1741

Which sorts rows in sql?

1016

what is a materialized view? : Sql dba

1061

Does sql between include endpoints?

1001

List the different type of joins?

1059

What is sqlcommand?

1026

Which operator is used in query for pattern matching?

1087

What are field types?

998

What trigger means?

975

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2217