select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_35 Where idCorp=1800000121 and iProject=35 and (field9 like '%电子信息产业固定资产投资情况%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_35 Where idCorp=1800000121 and iProject=35 and (field2 like '%电子信息产业固定资产投资情况%')) a where irecord<>813 group by iRecord,ord order by ord asc,iRecord desc
йͶָ