SQL
gavinkelland
这个作者很懒,什么都没留下…
展开
-
sql 的递归含下级查询(同一张表)
含下级:select a.id from 表 a start with a.id='123'connect by prior a.id=a.parentid含上级:select a.id from 表 a start with a.id='123' connect by prior a.parentid=a.id含下一级:select a.id from 表 a start wi原创 2015-06-12 11:50:17 · 3775 阅读 · 0 评论 -
子查询批量修改
多表:update JC_KEYWORD a set a.classifyName = (select b.classify from classify b where a.classifyId=b.classifyId) where exists (select 1 from classify b where a.classifyid=b.classifyid)单表:up原创 2015-10-13 16:22:44 · 568 阅读 · 0 评论 -
mysql删除重复数据
delete from lptemporary where docid in (select tt.docid from ( (select docid from lptemporary group by 重复字段 having count(*) > 1) ) tt)原创 2016-06-02 14:59:07 · 205 阅读 · 0 评论 -
mysql单表递归查询
一、向下递归:DROP FUNCTION IF EXISTS getAllChildren;CREATE FUNCTION queryChildrenAreaInfo(parentId INT)RETURNS VARCHAR(4000)BEGINDECLARE sTemp VARCHAR(4000);DECLARE sTempChd VARCHAR(4000);SET sTemp='$';原创 2017-05-11 11:13:11 · 2764 阅读 · 0 评论 -
mongo mapReduce 查询
db.getCollection('com.sup.pojo.Table').mapReduce( function(){ //map emit(this.instanceId,this.rent); }, function(keys,values){ //redus var arr = n...转载 2019-02-18 17:05:29 · 270 阅读 · 0 评论