Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What schema means?

939


Do foreign keys improve performance?

1068


What is the difference between microsoft access and sql server?

1107


What is rtm in testing?

1175


What is query syntax?

1020


Define implicit and explicit cursors.

1207


What is the use of & in pl sql?

1097


What is a common use of group by in sql?

1096


What is the difference between row level and statement level trigger?

1072


Explain what is table in a database?

1110


What are the different types of triggers?

1191


What is multiple partition?

1019


how can we destroy the cookie? : Sql dba

1082


What is before trigger?

1050


How do I view an execution plan in sql?

1035