限制每条SQL语句最多插入2000条后,问题解决
摘要:if (dataList.size() > 0) { new Thread() { @Override public void run() { //为了防止SQL语句超出长度出错,分成几次插入 if(dataList.size()<=2000){ nodeDataService.save(dataL
阅读全文
posted @
2020-11-26 13:23
花非花-雾非雾
oracle分组后得到主键
摘要:--查询emp中相同部门工资最高的select * from (--通过t.deptno分组,并按工资排序select t.*, row_number() over(partition by t.dept_id order by t.user_id desc) as rowindex from 表名
阅读全文
posted @
2020-11-13 14:46
花非花-雾非雾