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

Can we rollback after truncate?

1027

Why do we use sqlite?

966

What is a call statement? Explain with an example.

1000

Is left join inner or outer?

1012

How to fetch alternate records from a table?

1228

What is the most important ddl statements in sql are?

991

How we can update the view?

1048

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1036

What is cursor and why it is required?

1178

How many types of cursors supported in pl/sql?

1181

What is normalisation and its types?

997

what is rdbms? : Sql dba

1012

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4273

What does the sign mean in sql?

984

how to use myisamchk to check or repair myisam tables? : Sql dba

967