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
15526 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

Can there be 2 primary keys in a table?

998

what is clause? : Sql dba

1066

What is trigger and types?

1030

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1003

Does sqlite need a server?

1053

What is integrity in sql?

1051

how to decrement dates by 1 in mysql? : Sql dba

1021

Is left join inner or outer?

1023

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1160

What are user defined functions?

1024

What is difference between stored procedure and trigger?

1171

Which join is like inner join?

1031

What is sharding in sql?

991

What is the difference between delete and truncate commands?

1042

How do sql databases work?

1003