select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_23 Where idCorp=1800000121 and iProject=23 and (field12 like '%从事污染防治的第三方企业所得税%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_23 Where idCorp=1800000121 and iProject=23 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