使用如下哪个SELECT语句可从系统日期中提取月份并以“05”格式显示()
A.SELECTTRUNC(SYSDATE,'mm')FROMdual
B.SELECTTRUNCATE(SYSDATE,'mm')FROMdual
C.SELECTTO_CHAR(SYSDATE,'mm') FROMdual
D.SELECTDECODE(SYSDATE,'mm') FROMdual
SELECTTO_CHAR(SYSDATE'MM')FROMDUAL;
A.SELECTTRUNC(SYSDATE,'mm')FROMdual
B.SELECTTRUNCATE(SYSDATE,'mm')FROMdual
C.SELECTTO_CHAR(SYSDATE,'mm') FROMdual
D.SELECTDECODE(SYSDATE,'mm') FROMdual
SELECTTO_CHAR(SYSDATE'MM')FROMDUAL;
A、SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName, SalesDate
B、SELECT CustomerName, SalesDate FROM Sales ORDER BY SalesDate DESC, CustomerName
C、SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName, SalesDate DESC
D、SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName DESC
A.SELECT学号,姓名FROMSWHERENOTEXISTS(SELECT﹡FROMSCWHERESC.学号=S.学号AND成绩<85)
B.SELECT学号,姓名FROMSWHERENOTEXISTS(SELECT﹡FROMSCWHERESC.学号=S.学号AND成绩>=85)
C.SELECTS.学号,姓名FROMS,SCWHERES.学号=SC.学号AND成绩>=85
D.SELECT学号,姓名FROMS,SCWHERES.学号=SC.学号ANDALL成绩>=85
A.SELECT职工号,姓名FROM职工WHERESNAME=’李%’
B.SELECT职工号,姓名FROM职工WHERESNAMELIKE’李%’
C.SELECT职工号,姓名FROM职工WHERESNAME=’%李%’
D.SELECT职工号,姓名FROM职工WHERESNAMELIKE’%
A.当前页
B.每页显示的条数
C.起始位置
D.总条数
A.SELECT*FROMstockWHERE单价<=15.20.AND.单价>=12.76
B.SELECT*FROMstockWHERE单价<15.20.AND.单价>12.76
C.SELECT*FROMstockWHERE单价>=15.20.AN
D.单价<=12.76、D.SELECT*FROMstockWHERE单价>15.20.AND.单价<12.76
A.select1,2,3,4,5frominforamation_schema
B.orderby数字
C.通过unionselectnull,增加null的数量逐个去试
D.orderby列名
A.select1,2,3,4,5frominforamation_schema
B.orderby数字
C.通过unionselectnull,增加null的数量逐个去试
D.orderby列名
A.SELECTSN,AGE,SEXFROMSWHEREAGE>(SELECTAGEFROMS;WHERESN='王华')
B.SELECTSN,AGE,SEXFROMSWHERESN='王华'
C.SELECTSN,ACE,SEXFROMSWHEREAGE>(SELECTACEWHERESN='王华')
D.SELECTSN,ACE,SEXFROMSWHEREACE>王华AGE
A.语句可以执行,但是这条数据会被当作脏数据丢弃
B.目标表与源表中的数据类型不一致,执行出错
C.提交SQL时会报语法错误
D.语句可以执行,order_amt的值会被自动的转为double类型