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 '%Iceland%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Iceland%')) a where irecord<>48613 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Iceland's fish catch down 31 pct in March
Iceland's trade deficit increases in March
Iceland's CPI up 0.37 pct in March
Iceland's wage index records 3.5 pct increase in February
Iceland's GDP predicted to grow by 4 pct in 2016