Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version


PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit


create table sales(
txn_amt int,
txn_date_key numeric(8),
order_item_unit_status varchar(220)
);

Insert into sales values(1600,20190701,'DELIVERED');
Insert into sales values(1600,20190701,'DELIVERED');
Insert into sales values(1500,20210631,'RETURNED');
Insert into sales values(1500,20210631,'RETURNED');
1 rows affected

1 rows affected

1 rows affected

1 rows affected

select * from sales


txn_amt
txn_date_key
order_item_unit_status


1600
20190701
DELIVERED

1600
20190701
DELIVERED

1500
20210631
RETURNED

1500
20210631
RETURNED

txn_amt	txn_date_key	order_item_unit_status
1600	20190701	DELIVERED
1600	20190701	DELIVERED
1500	20210631	RETURNED
1500	20210631	RETURNED