Need query

From: Firthouse banu <penguinsfairy(at)gmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Need query
Date: 2021-07-17 07:24:57
Message-ID: CAK_Ha4xccRpDqzC-M5NWXn1+saRXbC_PVn3Rw0Lo=qBHxQDhuw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2021-07-17 07:53:38 Re: Need query
Previous Message David G. Johnston 2021-07-16 16:33:16 Re: pg_wal directory