A.select B.surpass C.support D.succeed
A.select
B. surpass
C. support
D. succeed
A.select
B. surpass
C. support
D. succeed
The course can help you to ______.
A.select your career interests
B.make suggestions to your friend
C.design you investigation
D.find solutions to many issues
以下语句错误的是()
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
从数据表 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
B.INSERT
C.UPDATE
D.DELETE
查询订购单号(字符型,长度为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"
要查询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操作
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