Over – ilość pozycji

SELECT 
  invoice_number,
  invoice_hash,
  seller_address,
  payment_method,
  sale_date,
COUNT(*) OVER() as total
FROM purchase_invoices;

-- ABC/123/2026 | bUkGCk34... | ul. Testowa 4 | Przelew | 2026-01-24 | 1