select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field7 like '%Switzerland%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Switzerland%')) a where irecord<>48665 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Switzerland to expect lowest annual growth since 2009
Unemployment rate in Switzerland stable in July: report
Number of jobless in Switzerland drops in April: figures
Unemployment in Switzerland on the rise: report
China, Switzerland eye deepened economic cooperation