oracle
孟金龙
这个作者很懒,什么都没留下…
展开
-
常用SQL语句二
查询:select * from table增加/插入:insert into table(name1,name2,) values ('列1','列2');修改/更新update table set name1='张三',name2='李四' where id=500;删除:delete from table where id=300;删除table 表里i...原创 2019-07-18 13:03:33 · 106 阅读 · 0 评论 -
sql四则运算,oracle语法
select ename,sal * 12 income from emp;select * from emp where sal>1500;select * from emp where is not null;select * from emp where is null;select * from emp where sal > 1500 and comm is ...原创 2019-07-18 16:58:34 · 959 阅读 · 0 评论