通过transaction_code显示数据库组中的数据

Question

In my database I create table name orders where the structure is transaction_code, date, customer_name, product_description, quantity, total_quantity all field have data.

In my previous activity I use while loop to display data from the table and it works ok, in this situation i would like to group all rows have same transaction_code

image below show my database structure with data

Answer 1

select * from orders group by transaction_code