select decode(col1,'a','a','b','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 / vikneswaran

11 Answers
15576 Views
I also Faced
E-Mail Answers

Answer Posted / vikneswaran

select decode(col1,'a','a','b','b','Other') "col1",count
(col1) "countval"
from col group by col1;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is file based approach?

948

What is the difference between rename and alias?

1352

what is view? : Sql dba

981

Enlist some predefined exceptions?

1069

What is trigger in flip flop?

1019

What are tuples in sql?

1144

Can we use commit inside a trigger?

1103

what is blob? : Sql dba

1158

What is nosql vs sql?

1184

What is sqlerrd?

972

Explain about various levels of constraint.

953

What are the benefits of stored procedures?

1081

which operator is used in query for pattern matching? : Sql dba

1011

What is data control language?

999

Can function return multiple values in sql?

1066