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 difference between in and between in sql?
how would you enter characters as hex numbers? : Sql dba
How to install oracle sql developer?
What is the use of index in sql?
What are the two parts of design view?
What is record data type?
Enlist the characteristics of pl/sql?
Where is sql database stored?
What does 0 mean in sql?
Why schema is used in sql?
What is a variable in sql?
How do you concatenate in sql?
what is a unique key ? : Sql dba
What is form and report?
What is data type in database?