单选题
在SQL Server中,查找authors表中的所有电话号码的首位为4,第二位为0或1的电话号码,以下语句正确的是( )
A
SELECT phone FROM authors WHERE phone LIKE '4[1,0]%'
B
SELECT phone FROM authors WHERE phone in '4[^10]%'
C
SELECT phone FROM authors WHERE phone LIKE '4_[1,0]%'
D
SELECT phone FROM authors WHERE phone between '41%' and '40%'
答案解析
正确答案:A
解析:
概念理解
