Which of the following commands does NOT include a customer with the first name 'BONITA' in the query results?单项选择题

A

SELECT * FROM customers WHERE firstname LIKE 'B_%';

B

SELECT * FROM customers WHERE firstname LIKE  '%N%';

C

SELECT * FROM customers WHERE firstname BETWEEN 'A' AND 'B';

D

SELECT * FROM customers WHERE firstname LIKE '%A';

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

类似问题

The screenshot below shows all customers whose name begins with B. Complete the missing SQL necessary to product this output. [Fill in the blank] [Fill in the blank]

Question at position 26 What does this SQL statement return? SELECT name FROM students WHERE name LIKE '%to%'; all names with "to," such as Roberto and Tommy all names without "to," such as Samantha or Kathryn all names starting with "to," such as Tommy or Tony all names ending with "to," such as Roberto

Question at position 25 What does this SQL statement return? SELECT name FROM students WHERE name LIKE '%to%'; all names starting with "to," such as Tommy or Tony all names ending with "to," such as Roberto all names with "to," such as Roberto and Tommy all names without "to," such as Samantha or Kathryn

Which of the following is a possible output from the expression WHERE name = '%D%' 1. %D% 2. Dan 3. Little Dan  

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！