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
Answer Posted / lizamishra15
pls answer me this qeustion
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can sql function call stored procedure?
What is sqlcommand?
What is bulk collect in pl sql?
When sql appeared?
How will you distinguish a global variable with a local variable in pl/sql?
what are the properties and different types of sub-queries? : Sql dba
What is nvl?
Explain what is a database?
What is trigger in sql?
Explain the types of joins in sql?
Is it possible to sort a column using a column alias?
how to convert character strings to dates? : Sql dba
What are the types of index in sql?
What is an intersect?
What is the difference between function, procedure and package in pl/sql?