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