select decode(dept_id,1,1,2,2,0) "cnt" ,count(decode (dept

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

11 Answers
15506 Views
I also Faced
E-Mail Answers

Answer Posted / kumarvijay

select decode(dept_id,1,1,2,2,0) "cnt" ,count(decode
(dept_id,1,1,2,2,0))
from deps group by decode(dept_id,1,1,2,2,0);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use sql constraints?

1171

How do I enable sql encryption?

1035

What is sql and how does it work?

1175

How many primary keys can a table have?

1009

What is the difference between null value, zero, and blank space?

1206

What is the difference between inner join and outer join?

996

What is sql lookup?

920

What are the parts of a sql statement?

1090

How many sql statements are used?

1011

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

1072

What is an implicit commit?

1058

What is 19 null in sql?

968

How do you rename a table in sql?

1113

What is a primary key called that is made up of more than one field?

1351

Why do we create views in sql?

1154