However, having the sequence restart at 1 for each unique value of A (a new UPC) allows us to store F in a smallint, which saves us almost 10% of space per observation over forcing F to be unique.

I am trying to write a query that shows me how much I sold to every customer every day over the last 60 days. I want a day represented in my resulting dataset even if there were no sales on that ...

With the introduction of Oracle compatibility in MariaDB Server 10.3, it's now possible to use Oracle PL/SQL and Oracle sequences in an open source database - making it easier for DBAs and developers ...