当前位置: X题卡 > 所有题目 > 题目详情

若要求查找姓“王”的学生的学号和姓名。下面列出的SQL语句中正确的是 ______。 Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME='王%' Ⅱ.SELECT S#,S...

查看本题答案

你可能感兴趣的试题

SELECT SNO,SNAME FROM S WHERE SNAME=′王%′  SELECT SNO,SNAME FROM S WHERE SNAME=′王_′  SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王%′  SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王_′  
SELECT SNO,SNAME FROMSWHERE SNAME=’王%’  SELECT SNO,SNAME FROM S WHERE SNAME=’王_’  SELECT SNO,SNAMEFROMS WHERE SNAME LIKE ’王%’  SELECT SNO,SNAME FROM S WHERE SNAME LIKE ’王_’  

热门试题

更多