select name ,count(name)as cnt from ( select case when ((name ='a�

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 / rakesh prasad

11 Answers
15452 Views
I also Faced
E-Mail Answers

Answer Posted / rakesh prasad

select name ,count(name)as cnt from (
select case when ((name ='a') or (name = 'b') )then name
else
'others' end as 'name' from tbl_count ) as temp group by
name

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger price?

984

What are the 3 modes of parameter?

1152

Explain how exception handling is done in advance pl/sql?

996

what is 'trigger' in sql? : Sql dba

1082

Is sqlite thread safe?

1044

Is sql a microsoft product?

946

Does truncate need commit?

941

What is pl sql record in oracle?

1026

Why do we use subquery?

1010

What does count (*) mean in sql?

1581

What is localdb mssqllocaldb?

1066

how to include character strings in sql statements? : Sql dba

1067

Why use triggers in sql?

955

What is sql keyword?

997

Which is better join or subquery?

1134