暂无图片
返回数说广场
杨凯同学
2024-11-05
查看表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
分享

评论

热门数说