要给嵌套sql的列例子

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)