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

How do you optimize a stored procedure query?

939

Is trigger a stored procedure?

887

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

990

What is meant by cursor in sql?

943

how to extract a unit value from a date and time? : Sql dba

948

what is top in tsql? : Transact sql

1026

How does cross join work?

878

How do we use distinct statement? What is its use?

977

Is primary key is clustered index?

942

What is the use of prepared statement?

954

How do I partition in sql?

905

What is insert command in sql?

1062

Can we use ddl commands in pl sql?

1075

What is database white box testing and black box testing?

1049

Can a table contain multiple foreign key’s?

950