17,377
社区成员
发帖
与我相关
我的任务
分享
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