mysql一张表自关联查询_MYSQL 一张表的自关联查询-阿里云开发者社区

MYSQL 一张表的自关联查询

程序员诗人

2017-12-20

944浏览量

简介：

SELECT

a.id id,

a.gmt_create gmtCreate,

a.gmt_modified gmtModified,

a.app_id appId,

a.

SELECT

a.id id,

a.gmt_create gmtCreate,

a.gmt_modified gmtModified,

a.app_id appId,

a.app_name appName,

a.dept_no deptNo,

a.dept_name deptName,

a.aone_product_id aoneProductId,

a.aone_product_name aoneProductName,

a.app_score appScore,

a.line_count lineCount,

a.complexity complexity,

a.duplication duplication,

a.comment_rate commentRate,

a.ut_rate utRate,

a.ui_rate uiRate,

a.it_rate itRate,

a.static_code_check_value1 staticCodeCheckValue1,

a.static_code_check_value2 staticCodeCheckValue2,

a.static_code_check_value3 staticCodeCheckValue3,

a.date_stamp dateStamp,

a.deviation deviation,

b.app_score appScoreRelative,

b.complexity complexityRelative,

b.duplication duplicationRelative,

b.comment_rate commentRateRelative,

b.ut_rate utRateRelative,

b.ui_rate uiRateRelative,

b.it_rate itRateRelative,

b.static_code_check_value1 staticCodeCheckValue1Relative,

b.static_code_check_value2 staticCodeCheckValue2Relative,

b.static_code_check_value3 staticCodeCheckValue3Relative

FROM quality_data_of_app a

join quality_data_of_app b

on a.app_id = b.app_id

where a.date_stamp =

(SELECT date(date_stamp) FROM quality_data_of_app

group by date(date_stamp)

order by date(date_stamp) desc limit 1) and

b.date_stamp =

(SELECT date_add(date(date_stamp), interval -30 day) FROM quality_data_of_app

group by date(date_stamp)

order by date(date_stamp) desc limit 1) and

a.dept_name like concat( #{deptName}, '%') and

a.aone_product_id = #{aoneProductId};

关系型数据库

MySQL

版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

分享：