知识点结查询语句.pdfVIP

SELECTTOP2*FROM(

SELECTMAX(grade)ASmaxgrade,usrId

FROMexm_competition

GROUPBYusrId

)b

ORDERBYmaxgrade

Stringsql=SELECT*FROM(SELECTtraourseId,sumTimeFROM

lrn_myTraoursemtcWHEREmtc.usrId=

+userId

+)aJOIN(SELECTtraourseId,

AVG(CONVERT(int,sumTime))asavgALLFROMlrn_myTraoursemtcGROUP

BYtraourseId)bONa.traourseId=b.traourseId;

Stringsql=SELECT*FROMklg_bookChapterbcWHEREbc.idIN

(SELECTtcc.chapterIdFROMlrn_tra