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 a recursive join sql?
Does pdo prevent sql injection?
How do I start sql profiler?
What are the types of records?
what is bdb (berkeleydb)? : Sql dba
Can we commit inside a trigger?
what is 'mysqlimport'? : Sql dba
What are the different types of a subquery?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Explain the order of sql statement execution?
What is difference between function and trigger?
how to load data files into tables with 'mysqlimport'? : Sql dba
What do you understand by case manipulation functions?
Where is all the data on the internet stored?
Does sql*plus have a pl/sql engine?