I have a table that has columns like following. Batch number is a database design thing like row number
demand_id batch_number debit status customer 34 1 yes 34 2 jack 35 1 no 35 2 kate
I want to create a query that would return this:
demand_id debit status customer 34 yes jake 35 no kate
How can I do that?