Skip to content

Instantly share code, notes, and snippets.

@petrhnilica

petrhnilica/nejstarsi_zbytek_podle_fifo.sql

Last active September 6, 2019 16:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save petrhnilica/1f5a8c27d3651b438192fdb3c1a535ad to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save petrhnilica/1f5a8c27d3651b438192fdb3c1a535ad to your computer and use it in GitHub Desktop.
Download ZIP
Flexibee 10 nejstarších zbývajících položek se zbožím na skladu
Raw
nejstarsi_zbytek_podle_fifo.sql
select *
from (select row_number () over (partition by p.kod order by p.datvyst, sum(p.mnozmj) - sum(coalesce(s.kusu,0))) as rk,
p.kod, p.datvyst, p.idpolsklad, p.iddoklsklad, sum(p.mnozmj) - sum(coalesce(s.kusu,0)) zbyva
from dpolsklad p
LEFT JOIN ddoklsklad d ON (d.iddoklsklad = p.iddoklsklad)
left join sfifovazby s on (p.idpolsklad = s.idpolskladprijem)
WHERE d.typpohybuk = 'typPohybu.prijem'
group by p.kod, p.datvyst, p.idpolsklad
having sum(p.mnozmj) <> sum(s.kusu) or sum(s.kusu) is null) as t
where rk <= 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment