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
What are different types of sql?
what is uncommittable transactions? : Transact sql
Can you do multiple joins in sql?
What does (*) mean in sql?
How do I turn a list into a table?
What is rollback?
how are mysql timestamps seen to a user? : Sql dba
What are synonyms in sql?
How do you use collections in procedure to return the resultset?
What are different categories of sql commands?
Can primary key be changed?
How does an execution block start and end in pl sql?
What is java sql drivermanager?
What is rank function in sql?
how to enter binary numbers in sql statements? : Sql dba