select entity,sum(decode(zone,'east',1,0)) east,

table having two columns - entity,zone
enity zone
pen east
pen west
pen north
pen south
pen east
pencil east
pencil east
pencil west

I want the output as :
entity east west north south
pen 2 1 1 1
pencil 2 1 0 0

Question Posted / aswini mohanty

2 Answers
4894 Views
I also Faced
E-Mail Answers

Answer Posted / aswini mohanty

select entity,sum(decode(zone,'east',1,0)) east,
sum(decode(zone,'west',1,0)) west,
sum(decode(zone,'north',1,0))north,
sum(decode(zone,'south',1,0))south
from t group by entity;

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I find duplicates in two columns?

1060

what is sql profiler? : Sql dba

997

what are the types of join and explain each? : Sql dba

991

How to get list of all tables from a database?

1109

What are system versioned tables?

969

What is latest version of sql?

984

Can we join same table in sql?

964

Is sql a scripting language?

925

What is the purpose of a sql?

915

How do you select unique values in sql?

938

What are the different schemas objects that can be created using pl/sql?

969

Explain the uses of database trigger.

1055

How do I view a sql trace file?

961

What is the difference between the conventional and direct path loads? : aql loader

1318

What is rowid in sql?

909