复制
收藏
提问
全网

11.要查询XS表中姓“王”的学生情况,可用( )命令 A、SELECT * FROM XS WHERE 姓名 LIKE ‘王%’ B、SELECT * FROM XS WHERE 姓名 LIKE ‘王_’ C、SELECT * FROM XS WHERE 姓名 = ‘王%’ D、SELECT * FROM XS WHERE 姓名 = ‘王_’

5月前
全网
文档
学术
百科
知识库
时间不限
自动

理解问题11.要查询XS表中姓“王”的学生情况,可用( )命令 A、SELECT * FROM XS WHERE 姓名 LIKE ‘王%’ B、SELECT * FROM XS WHERE 姓名 LIKE ‘王_’ C、SELECT * FROM XS WHERE 姓名 = ‘王%’ D、SELECT * FROM XS WHERE 姓名 = ‘王_’

已完成理解11.要查询XS表中姓“王”的学生情况,可用( )命令 A、SELECT * FROM XS WHERE 姓名 LIKE ‘王%’ B、SELECT * FROM XS WHERE 姓名 LIKE ‘王_’ C、SELECT * FROM XS WHERE 姓名 = ‘王%’ D、SELECT * FROM XS WHERE 姓名 = ‘王_’

展开阅读网页

更专业一些
转笔记
专业
11.要查询XS表中姓“王”的学生情况,可用( )命令 A、SELECT * FROM XS WHERE 姓名 LIKE ‘王%’ B、SELECT * FROM XS WHERE 姓名 LIKE ‘王_’ C、SELECT * FROM XS WHERE 姓名 = ‘王%’ D、SELECT * FROM XS WHERE 姓名 = ‘王_’
不在提醒

更专业内容正在努力生成中
知识树
11.要查询XS表中姓“王”的学生情况,可用( )命令 A、SELECT * FROM XS WHERE 姓名 LIKE ‘王%’ B、SELECT * FROM XS WHERE 姓名 LIKE ‘王_’ C、SELECT * FROM XS WHERE 姓名 = ‘王%’ D、SELECT * FROM XS WHERE 姓名 = ‘王_’
SELECT 语句如何使用 LIKE 子句?
SQL中如何查询以特定字符开头的记录?
SQL LIKE语句中'%'和'_'的区别是什么?

以上内容由AI搜集生成,仅供参考

在线客服