select * from vw_ys_ghh000_mzdzbl A where 1=1 and ghlb00 <> -99999 and rownum <=1000  and jzys00='2041'  and ghrq00 >='20230601'  and ghrq00 <='20231114' order by ghrq00 desc,ghsj00 desc,ghid00 desc 

select A.GHID00 from ys_mzblws a where ghid00 in (4783920,4783276,4750019,4737336,4737305,4737013,4731843,4685902) and A.WSZT00<>'3' and A.BCWJMC<>'0' and A.BLXMBH in ('01','03')