qq_38844636的博客

http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx

http://blog.youkuaiyun.com/haiross/article/details/17586565

Oracle over(partition by ...order by ...)http://www.cnblogs.com/shined/archive/2013/01/16/2862809.htmloracle下lag和lead分析函数http://blog.youkuaiyun.com/thinkscape/article/details/8290894

http://www.cnblogs.com/252e/archive/2012/09/13/2682817.html查询及删除重复记录的SQL语句 1、查找表中多余的重复记录，重复记录是根据单个字段（Id）来判断 select * from 表 where Id in (select Id from 表 group byId having coun

http://www.cnblogs.com/always-online/archive/2015/10/30/4923532.htmlhttps://zhidao.baidu.com/question/559526581.html

Oracle格式模型（Format Models）：http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#g195443https://community.oracle.com/thread/2150121?start=0&tstart=0

第8.9章https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html#optimizer-hints-syntax

1)  查看执行计划http://www.tuicool.com/articles/I7B3E3Y2) Oracle执行计划中的连接方式的种类http://blog.youkuaiyun.com/ziwen00/article/details/87997873) SQL语句的连接优化实例http://blog.youkuaiyun.com/dataminer_2007/articl

MySQL 事务是如何实现的http://www.cnblogs.com/zhiqian-ali/p/5668199.html