两条记录合并一条的 sql

最新推荐文章于 2025-06-18 14:13:41 发布

原创最新推荐文章于 2025-06-18 14:13:41 发布 · 5.5k 阅读

0 ·

CC 4.0 BY-SA版权

sql 专栏收录该内容

2 篇文章

订阅专栏

此查询结合了用户基本信息、组织映射、测试统计信息，通过内联和左连接，实现了用户信息与测试统计数据的整合展示，按注册时间降序排列并限制返回前10条记录。

select eu.ID,
eu.UID,
eu.ID_NO,
eu.USER_NICK,
eu.USER_NAME,
eu.PWD_DIGEST,
eu.PWD_SALT,
eu.SEX,EMAIL,
eu.PHONE,
eu.STATUS,
eu.USER_TYPE,
eu.REG_SRC_ID,
eu.USER_LOC,
eu.GMT_BIRTH,
eu.GMT_CREATE,
eu.GMT_MODIFY,
et1.test_count,
et2.last_time

from EH_USER_INFO eu
inner join EH_USER_ORG_MAP euo on eu.uid = euo.uid
inner
join EH_ORGANIZATION eo on euo.org_id = eo.id
left join
EH_LOGON_INFO el on
eu.uid = el.uid and el.logon_type =
'DEFAULT' and
el.status = 'E'

left join eh_user_test_stat_info et1 on
et1.uid=eu.uid and et1.stat_type='all_count'

left join eh_user_test_stat_info et2 on
et2.uid=eu.uid and et2.stat_type='last_time'

where
eu.uid notnull

order by eu.gmt_create desc

limit 10
OFFSET 0