×
单选题
关系模式Sailors(sid,sname,age,ratring)下面哪个语句能够查找出sname属性值至少为四个字符长,并且开始和结束字符都是B的水手信息.
A
SELECT * FROM SAILORS WHERE sname like ＇B%%_B＇
B
SELECT * FROM SAILORS WHERE sname like＇B__%B＇
C
SELECT * FROM SAILORS WHERE sname like ＇B??*B＇
D
SELECT * FROM SAILORS WHERE sname like＇B**?B＇
答案解析
正确答案：B
