语句“select* from books where id=5”的含义是从表（）中选择（）字段值为5的记录。

更多“语句“select* from books where id=5”的含义是从表（）中选择（）字段值为5的记录。”相关的问题

第1题

[单选题] 查询book表中所有书名中包含“计算机”的书籍情况，可用（）语句。

A、SELECT*FROM book WHERE book_nameLIKE‘*计算机*’ B、SELECT*FROM book WHERE book_nameLIKE‘%计算机%’ C、SELECT*FROM book WHERE book_name=‘%计算机*’ D、SELECT*FROM book WHERE book_name=‘*计算机%’

点击查看答案

第2题

[多选题] 现有书目表book，包含字段：price（float）；现在查询一条书价最高的书目的详细信息，以下语句正确的是（）

A、select top 1 * from book order by price asc B、select top 1 * from book order by price desc C、select top 1 * from book where price= (select max (price)from book) D、select top 1 * from book where price= max(price)

点击查看答案

第3题

[单选题] BookStore数据库中有图书表Book（BookCode，BookName，Author，PublisherCode，PublishTime，PublishTime是datetime类型。查询Book表中的图书类别（BookSort），要求每个类别只显示一次。SQL语句：SELECT（）BookSort FROM Book

A、DISTINCT B、ONLY C、ONE D、PERCENT

点击查看答案

第4题

[单选题] You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use?（）

A、SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date; B、SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC; C、SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC; D、SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

点击查看答案

第5题

[] You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （） You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）

A、A. SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date; B、B. SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC; C、C. SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC; D、D. SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

点击查看答案

第6题

[判断题] 语句由基本元素、表达式等组成，通常包括赋值语句、GOTO语句、条件语句、输入/输出语句、循环语句及实现特殊功能的其它语句

点击查看答案

第7题

[填空题] 动词性谓语句包括（）谓语句、（）谓语句、（）谓语句、（）谓语句、（）谓语句等几种类型。

点击查看答案

第8题

[单选题] 以下关于switch语句和break语句的描述中不正确的是（）。

A、break语句不能用于循环语句和switch语句外的任何其它语句 B、switch语句中使用break语句或continue语句的作用相同 C、在循环语句中使用break语句是为了使流程跳出循环体，提前结束循环 D、在循环语句中使用continue语句是为了结束本次循环，而不是终止整个循环的执行。