MYSQL同一用户不同日期不同数据合并

您好，我在某一个贴子下看到了您的回复
帖子链接：https://bbs.csdn.net/topics/392362659?list=2035345&ops_request_misc=&request_id=&biz_id=104&utm_term=%E5%90%88%E5%B9%B6%E8%BF%9E%E7%BB%AD%E6%97%A5%E6%9C%9F&utm_medium=distribute.pc_search_result.none-task-bbs-2~discuss~sobaiduweb~default-7-392362659.bbs_rank&spm=1018.2226.3001.4452
我按照您回复的代码进行了自己的数据修改，但是我无法得出对应的结果，能劳烦您帮我检查我的问题出在哪里吗？十分感谢
因为我使用的是MYSQL，所以我使用DATEDIFF函数时返回月份它报错，故我修改成了以下代码，不知会不会是这块地方出错

```sql

select PERNR ,min(BEGDA) as BEGDA,max(ENDDA) as ENDDA,
COUNT(1) as 条数,MAX(SUBTY) as SUBTY,MAX(BTARGET)
from
(select *, DATEDIFF(BEGDA,'1900/01/01') as diff,
ROW_NUMBER() over (partition by PERNR order by BEGDA) as seq
from bonus.export) as A
group by PERNR, diff-seq

```

查询字段没有包含group by的列。

select PERNR ,diff-seq,min(BEGDA) as BEGDA,max(ENDDA) as ENDDA,
COUNT(1) as 条数,MAX(SUBTY) as SUBTY,MAX(BTARGET)
from
(select *, DATEDIFF(BEGDA,'1900/01/01') as diff,
ROW_NUMBER() over (partition by PERNR order by BEGDA) as seq
from bonus.export) as A
group by PERNR, diff-seq

```