How to concatenate 2 rows(records) into single record in postgresql query?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

All Posts People Badges

Tags (View all)

odoo v14 accounting v15 odoo16features

About this forum

Help

How to concatenate 2 rows(records) into single record in postgresql query?

postgresql reporting sql odoo pivot

4166 Views

vadivel

Hello Friends,

I am writing sql report for based on invoice records.I have got ouput as 2 rows for particular input. But i need to display those 2 rows in single row(need to merger them in single row,even how many rows,group by partner_id) for aging report purpose.Help me in this situation.Thanks in advance

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
Show two column instead of two rows in psql. postgresql sql pgadmin odoo	1 Jul 21	2996
SQL Query for many2many Solved postgresql sql odoo odoo10	13 Jul 24	12535
Can Moves History Report use Scheduled Data instead of Effective Date? reporting sql	0 Sep 24	129
Is there a way to aggregate pivot data by a specific UoM? reporting pivot	0 Jan 24	509
How do I group on a product attribute in the "Sale Analysis" pivot view? reporting pivot	0 May 24	947

This question has been flagged

Enjoying the discussion? Don't just read, join in!