Closed prayagupa closed 1 year ago
mysql> select distinct(warehouse) from Inventory;
+-----------+
| warehouse |
+-----------+
| De Moines |
| Seattle |
| Luyata |
+-----------+
3 rows in set (0.01 sec)
mysql> with w as (select warehouse, min(qty) qty from Inventory group by warehouse) select w.warehouse, w.qty from w;
+-----------+------+
| warehouse | qty |
+-----------+------+
| De Moines | 88 |
| Seattle | 99 |
| Luyata | 11 |
+-----------+------+
3 rows in set (0.01 sec)
mysql> with w as (select warehouse, min(qty) qty from Inventory group by warehouse) select i.warehouse, i.sku, i.qty from w join Inventory i on w.warehouse = i.warehouse and w.qty=i.qty;
+-----------+-------+------+
| warehouse | sku | qty |
+-----------+-------+------+
| De Moines | sku-1 | 88 |
| Seattle | sku-2 | 99 |
| Luyata | sku-3 | 11 |
+-----------+-------+------+
3 rows in set (0.00 sec)
index in timestamp with time zone
,
CREATE INDEX event__event_tstz__inverse_idx
ON eventstream (event_tstz DESC);
If its just timestamp
,
CREATE INDEX event__event_ts__idx
ON eventstream ((event_ts::DATE));
https://dev.mysql.com/doc/refman/8.0/en/char.html