更多“查询课程名称以“计算机”开头的记录的准则是()。A.In“计算机”B.Not“计算机*”C.Like“计算机*”D.Mid“ ”相关问题
  • 第1题:

    在课程表中要查找课程名称中包含“计算机”的课程,对应“课程名称”字段的正确准则表达式是______。

    A.计算机

    B.*计算机*“

    C.Like"*计算机,"

    D.Like"计算机"


    正确答案:C

  • 第2题:

    要查询book表中所有书名中以“计算机”开头的书籍的价格,可用()语句

    A.SELECT price FROM book WHERE book_name = ‘计算机*’

    B.SELECT price FROM book WHERE book_name LIKE ‘计算机*’

    C.SELECT price FROM book WHERE book_name = ‘计算机%’

    D.SELECT price FROM book WHERE book_name LIKE ‘计算机%’


    D

  • 第3题:

    要查询book表中所有书名中以“计算机”开头的书籍的价格,可用______语句。()

    A.SELECT price FROM book WHERE book_name =‘计算机*’

    B.SELECT price FROM book WHERE book_name LIKE‘计算机*’

    C.SELECT price FROM book WHERE book_name =‘计算机%’

    D.SELECT price FROM book WHERE book_name LIKE‘计算机%’


    D

  • 第4题:

    要查询book表中书名book中以“计算机”开头的书籍的价格,可用()语句

    A.select price from book where name = ‘计算机*’

    B.select price from book where name like ‘计算机*’

    C.select price from book where name = ‘计算机%’

    D.select price from book where name like ‘计算机%’


    B

  • 第5题:

    2、要查询book表中所有书名中以“计算机”开头的书籍的价格,可用()语句

    A.SELECT price FROM book WHERE book_name = ‘计算机*’

    B.SELECT price FROM book WHERE book_name LIKE ‘计算机*’

    C.SELECT price FROM book WHERE book_name = ‘计算机%’

    D.SELECT price FROM book WHERE book_name LIKE ‘计算机%’


    SELECT * FROM book WHERE book_name Like ‘计算机%’