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 '%Malaysia%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Malaysia%')) a where irecord<>51793 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Malaysia's CPI up 1.1 pct in September
Malaysia's international reserves stand at 103.4 bln USD
Malaysia's January production output rises 3.2 pct
Malaysian economy likely to grow moderately in April to June
Malaysia's November producer price index fell 2.9 pct on year