Postgres Pro
Downloads
Home   >   mailing lists

Re: Need query - Mailing list pgsql-admin

From Imre Samu
Subject Re: Need query
Date
Msg-id CAJnEWwkp6BWxFdByPjF41zuuPxWGPy5qNkJr2bOLr9V6OVv=Cw@mail.gmail.com
Whole thread Raw
In response to Need query  (Firthouse banu <penguinsfairy@gmail.com>)
List pgsql-admin
Tree view

Firthouse banu <penguinsfairy@gmail.com> ezt írta (időpont: 2021. júl. 17., Szo, 9:25):
Table1
Name      Fruit
A              Mango 
A              Apple
A               Grape
B.              Mango 
B.              Mango 
A.              Mango 
A.              Apple 

Output 
Name.   Mango   Apple   Grape
A.           2.            2.          1 
B.           2.             0.         0

Can anyone write query to get this desired output from table one in Postgres please. 

TIA

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Need query
Next
From: Thomas Kellerer
Date:
Subject: Re: Need query