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 '%Singapore%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Singapore%')) a where irecord<>52482 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Singapore's retail sales post sharp month-on-month rebound in June
Singapore's GDP growth for Q3 remains at 0.1 pct on year
Singapore's domestic banking lending grows by 1.37 pct on year in April
Singapore's economy forecast to grow 2.5 pct in 2019: survey
Singapore's CPI growth falls to 0.4 pct in January