From 0ef5c7d4aeea5906d34355cd7afb05d676d89ae9 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Fri, 5 Oct 2018 20:26:05 +0200 Subject: [PATCH] few simple reports to verify import --- reports.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 reports.sql diff --git a/reports.sql b/reports.sql new file mode 100644 index 0000000..ffbeb2e --- /dev/null +++ b/reports.sql @@ -0,0 +1,8 @@ + +select date_scanned,source_id,count(*),max(timestamp) - min(timestamp) as sec from ffzg_inventura group by date_scanned,source_id; + +select min(date_scanned),max(date_scanned),source_id,count(*) from ffzg_inventura group by source_id; + +-- duplicates + +select barcode,min(date_scanned),max(date_scanned),count(*) from ffzg_inventura group by barcode having count(barcode) > 1 ; -- 2.20.1