單項(xiàng)選擇題查找student表中所有電話號(hào)碼(列名:telephone)的第一位為8或6,第三位為0的電話號(hào)碼()。

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*’


您可能感興趣的試卷

你可能感興趣的試題

1.單項(xiàng)選擇題以下()語(yǔ)句從表TABLE_NAME中提取前10條記錄。

A.select*from TABLE_NAME where rowcount=10
B.selectTOP 10*from TABLE_NAME
C.selectTOPof 10*from TABLE_NAME
D.select*from TABLE_NAME wherer owcount<=10