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 is the primary key?
What is the sql query to display the current date?
Can you call pl/sql package functions from within a fast formula?
How to select random rows from a table?
List and explain the different types of join clauses supported in ansi-standard sql?
What is difference between group by and partition by?
What is sqlerrm?
What is meant by truncate in sql?
What is data types in sql?
How to handle bulk data?
What does the sign mean in sql?
How can we make an if statement within a select statement?
What are inner outer left and right joins in sql?
What are different methods to trace the pl/sql code?
Can dml statements be used in pl/sql?