我有两个表，一个是xy_history表，一个是xy_dwinfo，要求是查询一列表里面的日期减去当前日期要大于30天的数据，输出的字段有xy_dwinfo的d2,d21，xy_history的d2,d3,d5 typyid，xy_history的xyid对应xy_dwinfo的d21，求大神帮忙，可私聊加qq
java吧 关注：1,220,371贴子：12,671,540
- 2回复贴，共1页
select dh.d2,dh.d3,dh.d5,dh.typeid, (select d2 from xy_dwinfo where d21=dh.xyid) dwd2,(select d21 from xy_dwinfo where d21=dh.xyid) d21 from dw_history dh,
(select xyid,MAX(to_date(d3,'yyyy/mm/dd')) md from dw_history group by xyid) mh where dh.xyid=mh.xyid and (to_date(dh.d3,'yyyy/mm/dd'))=mh.md and (to_date(dh.d3,'yyyy/mm/dd')-SYSDATE)>30 order by d21
(select xyid,MAX(to_date(d3,'yyyy/mm/dd')) md from dw_history group by xyid) mh where dh.xyid=mh.xyid and (to_date(dh.d3,'yyyy/mm/dd'))=mh.md and (to_date(dh.d3,'yyyy/mm/dd')-SYSDATE)>30 order by d21
扫二维码下载贴吧客户端
下载贴吧APP
看高清直播、视频！
看高清直播、视频！
贴吧热议榜
- 1东北雨姐虚假宣传被罚165万元2266770
- 2王楚钦3-0林兆恒晋级16强2002392
- 3郑钦文VOGUE封面正式公开1959160
- 4TheShy力挺选手on1409157
- 5美国吹牛老爹派对名单曝光1292590
- 6BLG中单左手为ON洗白1271450
- 7理记回应实名举报江秋莲骗捐8年1006416
- 8Xun和Wei谁更适合上场829518
- 9战胜PSG后ON通宵玩大乱斗822932
- 10Bin使用贾克斯获得比赛MVP726516
