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 / vinu

11 Answers
14972 Views
I also Faced
E-Mail Answers

Answer Posted / vinu

select decode (col1,'a','a','b','b','others') col1,count(col1) from T1 group by decode (col1,'a','a','b','b','others')

Is This Answer Correct ?

9 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is null in pl/sql?

1019

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1066

Can we perform dml on view?

971

What is pl sql code?

988

What can you do with pl sql?

1031

What is a trigger in sql?

1156

what is a database? : Sql dba

1097

what is the difference between sql and t-sql? : Transact sql

1040

Mention what is the function that is used to transfer a pl/sql table log to a database table?

929

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1040

What are some predefined exceptions in pl/sql?

1054

What is audit logout in sql profiler?

973

What are the two types of cursors in pl sql?

1001

What is %type in sql?

912

What is a temporal data type?

974