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 schema means?
Do foreign keys improve performance?
What is the difference between microsoft access and sql server?
What is rtm in testing?
What is query syntax?
Define implicit and explicit cursors.
What is the use of & in pl sql?
What is a common use of group by in sql?
What is the difference between row level and statement level trigger?
Explain what is table in a database?
What are the different types of triggers?
What is multiple partition?
how can we destroy the cookie? : Sql dba
What is before trigger?
How do I view an execution plan in sql?