SQL
itdragons
独立思考
展开
-
Sql删除表中多余的重复记录,保证重复字段唯一
DELETE FROM 表名 WHERE 重复字段 IN ( SELECT a.id FROM ( SELECT MAX(重复字段) id FROM 表名 a WHERE EXISTS ( SELECT 1 FROM 表名 b WHERE a.重复字段=b.重复字段 GROUP BY 重复字段 HA原创 2016-06-01 23:07:39 · 432 阅读 · 0 评论 -
Sql递归查询
例子:select * from sys_org where orgid in (select orgid from sys_org start with orgid = '10000' connect by prior sys_org.orgid = sys_org.sorgid)查询orgid=‘00000’的下级菜单,以及下下级(sys_org.orgid = sys_o原创 2016-06-01 23:14:39 · 467 阅读 · 0 评论