- sql语句，求最大值，最小值，平均值
- 测试技术
SELECT *
FROM
(
SELECT
t1.broker_id,t1.broker_name,t2.thscode,t2.sec_id,sec_type,
t2.is_listing,t2.listed_status_code,t2.listed_status,t2.td_mkt,t2.sec_short_name_cn
FROM ashare_broker_monthly_report t1 INNER JOIN sec_basic_info t2
ON t1.broker_id = t2.issue_org_id
where listed_status_code ='213001'
AND is_listing =1
AND td_mkt_encode in ('212001','212100')
AND sec_type = 'A股'
GROUP BY t1.broker_id,t1.broker_name,t2.thscode,t2.sec_id
) m
INNER JOIN
(
SELECT dt,sec_type,sec_id, pe_ttm_ed 'PE_TTM(截止日期)',pb_lastest_ed 'PB_最新(截止日期)'
FROM stock_ttm_valuation_index
WHERE sec_type = 'A股' AND dt >= '2020-08-10' AND dt < '2020-08-17'
GROUP BY dt,sec_type,sec_id
ORDER BY dt DESC
) n
ON m.sec_id = n.sec_id ;
怎么改这个sql，才能求出红色框中的那个值的最大值，平均值- 妖公子 2020-09-22 19:45:21
- 阅读 2706 收藏 0 回答 2
- 邀请
- 收藏
- 分享
登录 后发表评论
- 推荐问答
- 换一换
- session超时自动退出到登录页面怎么实现浏览 1 回答 08-26
- H5在微信浏览器中获取openId浏览 1 回答 11-24
- 需求管理软件如何提升团队效率？浏览 1 回答 07-17
- 【话题】现在一块钱还可以买到什么？浏览 1 回答 11-03
![新浪微博](http://service.weibo.com/share/share.php?title=来自“51testing软件测试圈”的问答《sql语句，求最大值，最小值，平均值》&<div><span style="font-size: 14.8528px;">SELECT * </span></div><div><span style="font-size: 14.8528px;">FROM</span></div><div><span style="font-size: 14.8528px;">(</span></div><div><span style="font-size: 14.8528px;">SELECT </span></div><div><span style="font-size: 14.8528px;"> t1.broker_id,t1.broker_name,t2.thscode,t2.sec_id,sec_type,</span></div><div><span style="font-size: 14.8528px;"> t2.is_listing,t2.listed_status_code,t2.listed_status,t2.td_mkt,t2.sec_short_name_cn</span></div><div><span style="font-size: 14.8528px;">FROM ashare_broker_monthly_report t1 INNER JOIN sec_basic_info t2 </span></div><div><span style="font-size: 14.8528px;">ON t1.broker_id = t2.issue_org_id </span></div><div><span style="font-size: 14.8528px;">where listed_status_code ='213001'</span></div><div><span style="font-size: 14.8528px;"> AND is_listing =1</span></div><div><span style="font-size: 14.8528px;"> AND td_mkt_encode in ('212001','212100')</span></div><div><span style="font-size: 14.8528px;"> AND sec_type = 'A股'</span></div><div><span style="font-size: 14.8528px;">GROUP BY t1.broker_id,t1.broker_name,t2.thscode,t2.sec_id</span></div><div><span style="font-size: 14.8528px;">) m</span></div><div><span style="font-size: 14.8528px;">INNER JOIN </span></div><div><span style="font-size: 14.8528px;">(</span></div><div><span style="font-size: 14.8528px;">SELECT dt,sec_type,sec_id, pe_ttm_ed 'PE_TTM(截止日期)',pb_lastest_ed 'PB_最新(截止日期)'</span></div><div><span style="font-size: 14.8528px;">FROM stock_ttm_valuation_index</span></div><div><span style="font-size: 14.8528px;">WHERE sec_type = 'A股' AND dt >= '2020-08-10' AND dt < '2020-08-17'</span></div><div><span style="font-size: 14.8528px;">GROUP BY dt,sec_type,sec_id</span></div><div><span style="font-size: 14.8528px;">ORDER BY dt DESC</span></div><div><span style="font-size: 14.8528px;">) n</span></div><div><span style="font-size: 14.8528px;">ON m.sec_id = n.sec_id ;</span></div><img src="http://quan.51testing.com/uploads/wenda/20200922/20200922194335_95019.png">怎么改这个sql，才能求出红色框中的那个值的最大值，平均值&url=&content=utf-8&sourceUrl=&pic=){kind=link}
- 关于我们 联系我们 版权声明 广告服务 站长统计
- 建议使用IE 11.0以上浏览器，800×600以上分辨率，法律顾问：上海兰迪律师事务所 项棋律师
- 版权所有 上海博为峰软件技术股份有限公司 Copyright©51testing.com 2003-2024, 沪ICP备05003035号
- 投诉及意见反馈：webmaster@51testing.com; 业务联系：service@51testing.com021-64471599-8017
- 51testing软件测试圈微信