文档库 最新最全的文档下载
当前位置:文档库 › oracle 01

oracle 01

SELECT empno , ename , job FROM emp ;

job

SELECT job FROM emp ;

BETWEEN … AND sal>=1500 AND sal<=3000

1981

198111 ~ 19811231

'

SELECT * FROM emp WHERE hiredate BETWEEN '1-1 -81' AND '31-12-81' ;

BETWEEN … AND

smith

ename='smith'

SELECT * FROM emp WHERE ename='smith' ; smith

Oracle

SELECT * FROM emp WHERE ename='SMITH' ;

LIKE

SELECT * FROM emp

SELECT * FROM emp

>>==<<=

SQL<>!=

7369

<>

SELECT * FROM emp WHERE empno<>7369 ;

!=

SELECT * FROM emp WHERE empno!=7369 ;

相关文档
相关文档 最新文档