Home > mailing lists

Need query - Mailing list pgsql-admin

From	Firthouse banu
Subject	Need query
Date	July 17, 2021 07:24:57
Msg-id	CAK_Ha4xccRpDqzC-M5NWXn1+saRXbC_PVn3Rw0Lo=qBHxQDhuw@mail.gmail.com Whole thread Raw
Responses	Re: Need query Re: Need query Re: Need query
List	pgsql-admin

Table1

Name Fruit

A Mango

A Apple

A Grape

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

From: "David G. Johnston"
Date: 16 July 2021, 16:33:16
Subject: Re: pg_wal directory

From: "David G. Johnston"
Date: 17 July 2021, 07:53:38
Subject: Re: Need query