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
15454 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 dense_rank in sql?

983

What is a trigger in sql?

1200

Is nosql relational?

941

How do you know if a relationship is 2nf?

942

What is cross join sql?

916

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1005

Can a foreign key be null?

1078

How to change sql*plus system settings?

1051

What is oracle sql called?

922

Is not equal in sql?

1010

What are the types of operators available in sql?

1060

how to include numeric values in sql statements? : Sql dba

1098

What's the procedure?

924

how to create a table index in mysql? : Sql dba

1059

Define commit?

993