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
explain normalization concept? : Sql dba
Can we use rowid as primary key?
What is the difference between in and between in sql?
What is difference between ms sql and mysql?
what are the different type of sql's statements ? : Sql dba
What are procedures used for?
What is sql and its types?
What is offset in sql query?
Does sql profiler affect performance?
What is a sql schema used for?
What is %type in pl sql?
Is time a data type in sql?
Is sql easier than java?
What are the different types of functions in sql?
Which function is used to return remainder in a division operator in sql?