select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_25 Where idCorp=1800000121 and iProject=25 and (field8 like '%巴基斯坦 %') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_25 Where idCorp=1800000121 and iProject=25 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