單項(xiàng)選擇題

當(dāng)你執(zhí)行下列查詢:

下列哪個語句是Oracle數(shù)據(jù)庫中可用的ANSI兼容等價語句()

A.select.empno,ename,loc.from.emp.join.dept.on.emp.deptno=dept.deptno.where.substr(emp.ename,1,1)=‘S’
B.select.empno,ename,loc.from.emp,dept.on.emp.deptno=dept.deptno.where.substr(emp.ename,1,1)=‘S’
C.select.empno,ename,loc.from.emp.join.dept.where.emp.deptno=dept.deptno.and.substr(emp.ename,1,1)=‘S’
D.select.empno,ename,loc.from.emp.left.join.dept.on.emp.deptno=dept.deptno.and.Substr(emp.ename,1,1)=‘S’

微信掃碼免費(fèi)搜題