试题详情
- 单项选择题 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;
关注下方微信公众号，在线模考后查看
热门试题
- Which SQL statement
- Evaluate this SQL s
- Examine the structu
- In which two cases w
- Which SQL statement
- You need to give the
- Which substitution v
- Which two statements
- Which two statements
- Examinethedatafromth
- Evaluate the SQL st
- ExaminethedataintheE
- Examine the structu
- Examine the structu
- You need to design
- Examine the structu
- Examine the descrip
- EXHIBIT,EmpTable Ex
- Which two statements
- Which three statemen