sql查询最新数据

最新推荐文章于 2024-09-27 11:25:54 发布

原创最新推荐文章于 2024-09-27 11:25:54 发布 · 930 阅读

0 ·

CC 4.0 BY-SA版权

该博客内容涉及复杂的SQL查询操作，包括子查询、聚合函数和分组，主要用于从特定数据表中筛选和提取特定指数代码和组织代码的数据。查询涉及到日期范围限制，并对结果进行排序，展示了对数据库管理和数据提取的深入理解。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select * from (select *  from (select  max(datadate) as datadate1,org_code as org_code1,index_code as index_code1 from "APP_DM_SCHEMA".lsds_apply where index_code in ('02040200045','12040200059','1204020060','12040200025') and org_code='F3202' and datadate<='2021-05-25' GROUP BY substring(datadate,1,4),org_code,index_code ORDER BY substring(datadate,1,4) desc) t,"APP_DM_SCHEMA".lsds_apply y where 
t.datadate1=y.datadate and t.org_code1=y.org_code and t.index_code1=y.index_code)tmp ORDER BY tmp.datadate desc`在这里插入

select y.* from "APP_DM_SCHEMA".lsds_apply y,(select  max(datadate) as datadate1,org_code as org_code1,index_code as index_code1 from "APP_DM_SCHEMA".lsds_apply where index_code in ('02040200045','12040200059','1204020060','12040200025') and org_code in ('F3202','F3204','F3215','F3217','F3203') and datadate<='2021-05-25' GROUP BY substring(datadate,1,4),org_code,index_code ORDER BY substring(datadate,1,4) desc) t  where 
t.datadate1=y.datadate and t.org_code1=y.org_code and t.index_code1=y.index_code   ORDER BY y.org_code,y.datadate desc