All pastes #239554 Raw Edit

Unnamed

public text v1 · immutable
·published 2006-11-05 11:40 UTC
rendered paste body
SELECT * FROM
obroty_dokumentow obrdokx
inner join (Select obrdok.id_materialu, max(obrdok.rekord_hurtu) as max_rekord  from obroty_dokumentow obrdok group by obrdok.id_materialu) YY on
    obrdokx.id_obrotu = yy.id_obrotu
    and obrdokx.rekord_hurtu = yy.rekord_hurtu
    and obrdokx.data_obrotu = '2.11.2006'