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
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
What is the reports view in oracle sql developer?
How to run sql functions in pl/sql?
Does pdo prevent sql injection?
What is index example?
Can we debug stored procedure?
Does sql support programming?
When can we use the where clause and the having clause?
What's the procedure?
What is program debugging?
What are tables and fields?
How many commands are in sql?
What is sql query limit?
how to calculate the difference between two dates? : Sql dba
What are the sql versions?
what is union? : Sql dba