语句UPDATE student set name=’youjun’, grade=98.5的运行结果是()
A. 更新student表中第一条记录
B. 出错语法错误
C. 更新student表中最后一条记录
D. 更新 student表中每一条记录
查看答案
下面选项中,能够更新user表中数据的SQL语句是()
A. update into user set id = 'u001';
B. update user set id = 'u001' and username='jack';
C. update user set username='jack' where id = 1;
D. update into user set id = 'u001', username='jack';
下面选项中,用于过滤查询结果中重复数据的关键字是()
A. DISTINCT
B. HAVING
C. ORDER BY
D. LIMIT
在SELECT语句中用于指定表名的关键字是()
A. SELECT
B. FROM
C. ORDER BY
D. HAVING
SELECT语句中用于指定查询条件的关键字是()
A. WHILE
B. GROUP BY
C. WHERE
D. HAVING