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
Why is partition used in sql?
What is cte?
how many groups of data types? : Sql dba
How subquery works in sql?
What is the need of merge statement?
What is a table in a database?
What is the use of primary key?
What are the different parts of a package?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is sql integrity?
What is pl sql architecture?
What do you mean by table in sql?
What is the difference between alter trigger and drop trigger statements?
What is sql constant?
explain the options of myisamchk to improve the performance of a table. : Sql dba