17,382
社区成员




select count(*) as zs,su.subjectname from ISTIC_Data_CSTPCD_Article ar,ISTIC_Dic_SubjectCode su,ISTIC_Data_CSTPCD_Citation ci
where ar.xk=su.SUBJECTCODE and ar.pdfurl=ci.zz1
group by su.subjectname
Alter table table_name move;
Alter index index_name rebuild;
Alter trigger trigger_name compare;
select count(*) as zs,su.subjectname from ISTIC_Data_CSTPCD_Article ar,ISTIC_Dic_SubjectCode su,ISTIC_Data_CSTPCD_Citation ci
where ar.pdfurl=ci.zz1 and ar.xk=su.SUBJECTCODE
group by su.subjectname