select
fuc.STRIPNO as "stripno",
fuc.PRVPOS as "prvpos",
fuc.TOC as "toc",
fuc_data.MILLSIDEPOSITION as "millsideposition",
fuc_data.THICK
as "thick",
fuc_data.WIDTH
as "width",
fuc_data.LENGTH
as "length",
fuc_data.FURNO as "furno"
from H032.fuc_slabcalcudata fuc inner join H032.fuc_slab_actual_data fuc_data ON fuc.STRIPNO = fuc_data.STRIPNO
where 1=1 AND fuc_data.FURNO= '1' AND fuc.toc =
(SELECT f.toc FROM H032.fuc_slabcalcudata f inner join H032.fuc_slab_actual_data f_data on f.STRIPNO = f_data.STRIPNO
WHERE f_data.FURNO= '1' order by f.toc desc fetch first 1 row only)
from H032.fuc_slabcalcudata fuc inner join H032.fuc_slab_actual_data fuc_data ON fuc.STRIPNO = fuc_data.STRIPNO
where 1=1 AND fuc_data.FURNO= '1' AND fuc.toc =
(SELECT f.toc FROM H032.fuc_slabcalcudata f inner join H032.fuc_slab_actual_data f_data on f.STRIPNO = f_data.STRIPNO
WHERE f_data.FURNO= '1' order by f.toc desc fetch first 1 row only)