查找student表中所有电话号码(列名:telephone)的第一位为8或6,第三位为0的电话号码()。
- A、SELECT telephone FROM student WHERE telephoneLIKE’[8,6]%0*’
- B、SELECT telephone FROM student WHERE telephoneLIKE’(8,6)*0%’
- C、SELECT telephone FROM student WHERE telephoneLIKE’[8,6]_0%’
- D、SELECT telephone FROM student WHERE telephoneLIKE’[8,6]_0*’
正确答案:C
答案解析:有
微信扫一扫手机做题