哪位大佬,有时间帮帮忙啊,MySQL小白 :
insert into TEMP_BD_DAT_HMMY (R_ANIMAL, pig_id_from, FARM_ID)
SELECT pig_id, 1, farm_id from (select row_number() over(PARTITION BY pig_id order by arr_date desc) rn,
pig_id,farm_id from T_BOAR_PIGINFO_MOVED
where (BOR_DATE >= to_date('2016-7-19','YYYY-MM-DD')
and BOR_DATE <= to_date('2019-7-19','YYYY-MM-DD') )
and BREED_CODE ='MM'
and FARM_ID in ('530001', '100301')
and length(Dadid) > 0
and length(MaId) > 0
and sex in (0, 1)
and exists (select 1
from T_BREED_GROWTH a
where a.pig_id = T_BOAR_PIGINFO_MOVED.pig_id
and a.TEST_WT_END >= 85
and a.TEST_WT_END <= 130
and a.AVERAGE_BFT >= 4
and a.AVERAGE_BFT <= 30
and a.test_days_end >= 100
and a.test_days_end <= 300)
and not exists
(select 1
from TEMP_BD_DAT_HMMY x
where x.R_ANIMAL = T_BOAR_PIGINFO_MOVED.pig_id)) a
where a.rn = 1
帮我把这Oracle 语句改成MySQL的 谢谢了
Oracle语句转换成MySQL语句问题
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
- 打杂的程序员 2019-07-29 15:41关注
第二行的 高级查询over(PARTITION BY 改成关联查询。
时间转换的to_date 改成 str_to_date(date,'%Y-%m-%d') 。解决 无用评论 打赏 举报