题目内容

SQL语句中的条件用以下哪个关键字来表达( )

A. THEN
B. WHILE
C. WHERE
D. IF

查看答案
更多问题

查找条件为:姓名(name)不是NULL的记录( )

A. WHERE name ! NULL
B. WHERE name NOT NULL
C. WHERE name IS NOT NULL
D. WHERE name!=NULL

向数据表中插入一条记录使用的是哪个关键字( )

A. CREATE
B. INSERT
C. SAVE
D. UPDATE

以下删除记录正确的( )

A. DELETE FROM emp WHERE name='dony';
B. DELETE * FROM emp WHERE name='dony';
C. DROP FROM emp WHERE name='dony';
DROP * FROM emp WHERE name='dony';

按照姓名(name)降序排列( )

A. ORDER BY DESC name
B. ORDER BY name DESC
C. ORDER BY name ASC
D. ORDER BY ASC name

答案查题题库