How to Transpose rows into columns in SQLite or flutter moor?

71 views Asked by At

How can I convert rows into columns.

initial structure

Needed Output:

OrderId -> Product1 -> QuantityOfProduct1 -> ... ProductN -> QuantityOfProductN -> totalAmount -> Date

Please help me to achieve this. sorry for improper questioning. Thanks in advance.

0

There are 0 answers