04 2014 档案

Oracle keep详解
摘要：原题目select*fromdeptwheredeptno=(selectmax(deptno)keep(dense_ranklastorderbycount(1))fromempgroupbydeptno);解析：select max(deptno) keep(dense_rank last or... 阅读全文
posted @ 2014-04-15 23:24 ☆♂安♀★ 阅读(652) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示