每日一练002

查看如下表members结构：
Name Nulls Type
MEMBER_ID NOT NOLL VARCHAR2 (6)
FIRST_NAME VARCHAR2 (50)
LAST_NAME NOT NOLL VARCHAR2 (50)
ADDRESS VARCHAR2 (50)
CITY VARCHAR2 (25)
STATE VARCHAR2 (3)

列出state满足以字母A开头且后面只有一个字符的成员信息，如下哪个SQL正确？
A)SELECT * FROM MEMBERS WHERE state LIKE ‘%A_’ ;
B)SELECT * FROM MEMBERS WHERE state LIKE ’ A_% ’ ;
C)SELECT * FROM MEMBERS WHERE state LIKE ‘A_’;
D)SELECT * FROM MEMBERS WHERE state LIKE ‘A%’;
答案C
此题考点：模糊匹配通配符
% 可匹配多个字符
_ 可匹配单个字符