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 '%Sri Lankas %') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Sri Lankas %')) a where irecord<>0 group by iRecord,ord order by ord asc,iRecord desc
Invest in China
Homepage |
首页 新闻动态 法律服务 数据服务 项目服务 投资环境 投资服务机构 经济开发区
Macro-Economy | Business Economy | Industrial Economy | Regional Economy
Home >News >
Search
0 results   Page 1 of 1  First Previous 1 Next Last
 Site Map | About Us | Services | Links | Statement

Ministry of Commerce of the People's Republic of China Department of Foreign Investment Administration

Operated by Investment Promotion Agency of MOFCOM

Tel:  (86-10) 64404554

Copyright by Invest in China

Fax: (86-10) 64515317

ICP Record No.: Beijing ICP 06041048-4 E-mail: service@fdi.gov.cn