https://blog.youkuaiyun.com/YDYKLzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/YDYKL/article/details/8101349https://blog.youkuaiyun.com/YDYKL/article/details/8101349YDYKLTue, 23 Oct 2012 09:21:43 +0800https://blog.youkuaiyun.com/YDYKL/article/details/8012037https://blog.youkuaiyun.com/YDYKL/article/details/8012037YDYKLMon, 24 Sep 2012 11:11:25 +0800 select ename, sal from emp   2  join (select deptno, max(sal) max_sal from emp group by deptno) t   3  on (emp.deptno = t.deptno and emp.sal = t.max_sal); ----求各个部门平均薪水的等]]>https://blog.youkuaiyun.com/YDYKL/article/details/7931170https://blog.youkuaiyun.com/YDYKL/article/details/7931170YDYKLFri, 31 Aug 2012 23:22:17 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7909138https://blog.youkuaiyun.com/YDYKL/article/details/7909138YDYKLSun, 26 Aug 2012 15:18:10 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7894329https://blog.youkuaiyun.com/YDYKL/article/details/7894329YDYKLWed, 22 Aug 2012 09:42:31 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7859424https://blog.youkuaiyun.com/YDYKL/article/details/7859424YDYKLMon, 13 Aug 2012 11:45:48 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7561416https://blog.youkuaiyun.com/YDYKL/article/details/7561416YDYKLSun, 13 May 2012 00:33:13 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7461210https://blog.youkuaiyun.com/YDYKL/article/details/7461210YDYKLSat, 14 Apr 2012 18:47:28 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7401512https://blog.youkuaiyun.com/YDYKL/article/details/7401512YDYKLWed, 28 Mar 2012 09:24:21 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7375894https://blog.youkuaiyun.com/YDYKL/article/details/7375894YDYKLTue, 20 Mar 2012 22:29:34 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7352080https://blog.youkuaiyun.com/YDYKL/article/details/7352080YDYKLWed, 14 Mar 2012 11:00:09 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7350579https://blog.youkuaiyun.com/YDYKL/article/details/7350579YDYKLTue, 13 Mar 2012 21:12:15 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7315897https://blog.youkuaiyun.com/YDYKL/article/details/7315897YDYKLSat, 03 Mar 2012 20:43:25 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7315763https://blog.youkuaiyun.com/YDYKL/article/details/7315763YDYKLSat, 03 Mar 2012 19:49:11 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7096506https://blog.youkuaiyun.com/YDYKL/article/details/7096506YDYKLThu, 22 Dec 2011 19:55:45 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7096503https://blog.youkuaiyun.com/YDYKL/article/details/7096503YDYKLThu, 22 Dec 2011 19:54:00 +0800https://blog.youkuaiyun.com/YDYKL/article/details/7064998https://blog.youkuaiyun.com/YDYKL/article/details/7064998YDYKLMon, 12 Dec 2011 21:36:30 +0800https://blog.youkuaiyun.com/YDYKL/article/details/6957593https://blog.youkuaiyun.com/YDYKL/article/details/6957593YDYKLThu, 10 Nov 2011 20:13:35 +0800https://blog.youkuaiyun.com/YDYKL/article/details/6953678https://blog.youkuaiyun.com/YDYKL/article/details/6953678YDYKLWed, 09 Nov 2011 20:04:19 +0800https://blog.youkuaiyun.com/YDYKL/article/details/6945211https://blog.youkuaiyun.com/YDYKL/article/details/6945211YDYKLMon, 07 Nov 2011 20:13:34 +0800