排序:
默认
按更新时间
按访问量

left join 关联条件位置

select e.last_name, e.department_id, d.department_name from hr.employees e left outer join hr.departments d on (e.department_id = d.department_id...

2014-04-22 09:02:39

阅读数:537

评论数:0

利用分析函数删除重复数据

delete from dupes where rowid in (select rowid from (select a.*,row_number() over(partition by name order by name) as rn from dupes a) where rn>...

2014-03-19 19:50:51

阅读数:741

评论数:0

|| 连接运算符

|| --批量修改sequence: select 'alter sequence ' || SEQUENCE_OWNER ||'.'||sequence_name|| ' cache 1000;' from dba_sequences; ---批量drop 表: SQL>...

2014-03-19 19:39:37

阅读数:685

评论数:0

sql union代替or

---原始SQL SQL> SELECT deptno FROM emp WHERE empno = 7788 OR job = 'SALESMAN' ORDER BY 1; DEPTNO ---------- 20 30 30 30 30 SQL> SELECT...

2014-03-18 19:31:30

阅读数:919

评论数:2

提示
确定要删除当前文章?
取消 删除
关闭
关闭