返回数说广场
0
查看表CUSTOMERS的CUST_NAME列数据:
CUST_NAME
------------------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
你想要查看“last name”以“Mc”或“MC”开头的CUST_NAME列数据, 如下哪两个WHERE子句可以得出需要的结果?BD
A
WHERE SUBSTR(cust_name,INSTR(cust_name,' ') +1 ) LIKE 'Mc%' OR 'MC%'
B
WHERE UPPER (SUBSTR(cust_name, INSTR(cust_name, ' ') +1 ) ) LIKE UPPER('MC%')
C
WHERE SUBSTR(cust_name, INSTR(cust_name,' ') +1 ) LIKE 'Mc%'
D
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') +1 ) ) LIKE 'Mc%'
E
WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,' ') +1 ) ) IN ('MC%', 'Mc%)
0
0 198
分享
评论
热门数说


