- 博客(2)
- 资源 (1)
- 收藏
- 关注
原创 oracle 模糊查询语句 , 工作中用到的sql
<select id="findAll" resultMap="BaseMeterMap"> select * from (select rownum rownum_rn, a.* from(select am.meterId, am.meterBoxId, am.meter_name, am.meter_no, am.house_id, am.phase...
2019-08-08 11:53:26 557
原创 多表关联查询,工作中 用到的sql
select s1.data_id, s1.DISTRICTBCDID, s1.ADDRESSID, s1.INSERT_TIME, max(s1.DATA_VALUE) as DATA_VALUE, max(s2.EPU_LOCAL) as EPU_LOCAL from S_SENSOR_DATA s1 left join ( select s.data_id, s.DISTRICTB...
2019-08-08 09:00:44 128
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人