select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_33 Where idCorp=1800000121 and iProject=33 and (field10 like '%全国吸收外商直接投资快讯%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_33 Where idCorp=1800000121 and iProject=33 and (field2 like '%全国吸收外商直接投资快讯%')) a where irecord<>0 group by iRecord,ord order by ord asc,iRecord desc
йͶָ
Ϊҳ |  
Ͷҵѯ | ͳ | Ͷо
ҳ >ݷ >
  
0¼  1ҳ  1ҳ  ҳ ҳ 1 ҳ ĩҳ
 ȵע
 
bbbbbb
 վͼ | | ͻ | | վ
쵥λл񹲺͹Ͷʴٽ     (010) 64404550                 

ȨУйͶָ

    棺(010) 64515317

       վΪ񲿹Ϣվ

    䣺service@fdi.gov.cn
ţICP14022686