以下语句错误的是() A.select sal+1 from emp; B.select sal*10,sal*deptno from emp
以下语句错误的是()
A.select sal+1 from emp;
B.select sal*10,sal*deptno from emp;
C.不能使用运算符号
D.select sal*10,deptno*10 from emp;
以下语句错误的是()
A.select sal+1 from emp;
B.select sal*10,sal*deptno from emp;
C.不能使用运算符号
D.select sal*10,deptno*10 from emp;
关于group by 以下语句正确的是()
A.SELECT store_name FROM Store_Information GROUP BY store_name
B. SELECT SUM(sales) FROM Store_Information GROUP BY sales
C.SELECT store_name, price SUM(sales) FROM Store_Information GROUP BY store_name,price
D.SELECT store_name, SUM(sales) FROM Store_Information GROUP BY store_name
已知商品表的关系模式为:商品(商品编号,名称,类型),使用SQL语句查询类型为"食品"的商品信息,并按照类型降序排列,以下正确的是()。
A.SELECT*FROM商品WHERE类型="食品"ORDERBY类型DESC
B.SELECT*FROM商品WHERE类型="食品"ORDERBY类型ASC
C.SELECT*FROM商品WHERE类型="食品"ORDERBY食品ASC
D.SELECT*FROM商品WHERE类型="食品"DESC
A.SELECT
B.INSERT
C.UPDATE
D.DELETE
以下2题基于以下说明。设有三个关系
学生关系S(SNO,SNAME,AGE,SEX)(分别代表学生的学号、姓名、年龄、性别)
学习关系SC(SNO,CNO,GRADE)(分别代表学生的学号、课程编号、成绩)
课程关系C(CNO,CNAME,TEACHER)(分别代表课程的编号、课程名、任课教师)
“从学习关系SC中检索无成绩的学生学号”的SQL语句是
A.SELECT sno FROM sc WHERE grade=NULL
B.SELECT sno FROM sc WHERE grade IS
C.SELECT sno FROM sc WHERE grade IS NULL
D.SELECT sno FROM sc WHERE grade=0
从数据表 student 中查询张姓的所有学生,正确的 SQL语句是()。
A.SELECT sno,sname FROM student WHERE sname LIKE N' 张%'
B.SELECT sname FROM student WHERE sname = N'% 张%'
C.SELECT sno,sname FROM student WHERE sname LIKE N'% 张%'
D.SELECT sname FROM student WHERE sname = N' 张%'
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
要查询book表中所有书名以“电子商务”开头的书籍作者,可用(61)语句。
A.SELECT author FROM booK WHERE book _name=‘电子商务*’
B.SELECT author FROM booK WHERE book _name LIKE‘电子商务*’
C.SELECT author FROM booK WHERE book_ name=‘电子商务%’
D.SELECT author FROM booK WHERE book_name LIKE‘电子商务%’
A.select是DQL操作
B.delte是DML操作
C.truncate是DML操作
D.create是DDL操作
查询订购单号(字符型,长度为4)尾字符是“1”的错误命令是 ______。
A.SELECT * FROM 订单 WHERE SUBSTR(订购单号,4)="1"
B.SELECT * FROM 订单 WHERE SUBSTR(订购单号,4,1)="1"
C.SELECT * FROM 订单 WHERE "1"$订购单号
D.SELECT * FROM 订单 WHERE RIGHT(订购单号,1)="1"
A.CREATEDATABASEbook
B.CREATEDATABASEsh.book
C.CREATEDATABASEsh_book
D.CREATEDATABASE_book