The EMPLOYEES table contains these columns: EMPLOY...
单选题

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?()

发布日期:2020-04-10

A.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';

B.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

C.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;

D.SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定