在SQLServer中,SELECT语句中必须包含的子句是SELECT和()
A.INSERT
B.WHERE
C.JOIN
D.FROM
D、FROM
A.INSERT
B.WHERE
C.JOIN
D.FROM
D、FROM
A.BEGINTRANSACTION
B.ENDTRANSACTION
C.OMMITTRANSACTION
D.ROLLBACKTRANSACTION
A.selectemailfromstudentwhereemail!=null
B.selectemailfromstudentwhereemailnotisnull
C.selectemailfromstudentwhereemailnull
D.selectemailfromstudentwhereemailisnotnull
A.SELECTename,job,salFROMEMPWHEREdeptnoALL(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)
B.SELECTename,job,salFROMEMPWHEREdeptno=ANY(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)
C.SELECTename,job,salFROMEMPWHEREdeptnoANY(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)
D.SELECTename,job,salFROMEMPWHEREdeptnoIN(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)