A、sname LIKE ’_[^光明]%’
B、.sname LIKE ’_^光明%’
C、sname LIKE ’_光明%’
D、sname LIKE ’_[光明]%’
更多“设student表中存放了学生的信息，要从student表中查出姓名（sname）的第二个字是“光”或"明"的学生的信息，正确的查询语句为： select * from student where（）”相关的问题
A、SELECT*FROM students ORDERBYavg_grade B、SELECT*FROM students GROUPBYavg_grade ASC C、SELECT*FROM students ORDERBYavg_grade DESC D、SELECT*FROM students ORDERbyavg_gradeasc
A、实体Course和Discipline之间的关系是一对多 B、实体Course和Discipline之间的联系是多对多 C、实体Course和Student之间的联系是多对一 D、实体Discipline和Student之间的关系是一对一
A、Select email from student where email!=null B、Select email from student where emailnotisnull C、Select email from student where email<>null D、Select email from student where emailisnotnull
A、Select unique所在省市from Student B、Select所在省市from Student C、Select only所在省市from Student D、Select distinct所在省市from Student
A、Select* From Student Where ZZMM=’党员’And ZZMM=’团员’ B、Select* From Student Where ZZMM=’党员’Or ZZMM=’团员’ C、Select* From Student Where ZZMM="党员"OrZ ZMM="团员" D、Select* From Student Where ZZMM IN（’党员’，‘团员’）
客服
TOP
查看正确答案
