select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_21 Where idCorp=1800000121 and iProject=21 and (field7 like '%鑽峰叞%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_21 Where idCorp=1800000121 and iProject=21 and (field2 like '%鑽峰叞%')) a where irecord<>0 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
首页 > 工作动态
共0条记录  共1页  第1页  首页 上页 1 下页 末页