- 博客(3)
- 收藏
- 关注
原创 sql 中exists 代替 in
当td_zy_unitbasicinfo2 审核通过的数据而 td_zxjc_unitbasicinfo 中状态为未审核时,通过信用代码关联更新IF_AFTER_DECLARE 为1用in更新:update td_zxjc_unitbasicinfo T1 set IF_AFTER_DECLARE = 1 where IF_DECLARE = 0 and CREDIT_CODE in(select CREDIT_CODE from td_zy_unitbasicinfo2 T2 where DE
2020-11-24 18:38:57 231
原创 jdk 1.8 求和,最大,最小,平均值
list.stream().mapToDouble(User::getHeight).sum()//和list.stream().mapToDouble(User::getHeight).max()//最大list.stream().mapToDouble(User::getHeight).min()//最小list.stream().mapToDouble(User::getHeight).average()//平均值
2020-11-24 15:35:19 1009
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人