题目内容

下面选项中,能够更新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

SELECT语句中用于限制查询结果数量的关键字是()

A. SEELCT
B. GROUP BY
C. LIMIT
D. ORDER BY