Question

Oracle查询语句：根据A列不同的值，查询出最新创建的多条记录

具体需求：对表A的dwid(单位id)进行筛选，只显示一条记录，这条记录是根据表A的created列的时间进行筛选，以最新的时间段筛选出来。求大神看看SQL语句怎么写，感激！大概情况如图所示：

Answer 1

select A.dwid,B.max_created,A.xdq,A,xde from A,(select dwid,max(created) as max_created from A group by dwid) B where A.dwid=B.dwid and A.created=B.max_created;
这样写试一下。

Answer 2

Select Count(字段名),字段名 from 表名 group by 字段名

追问

老哥，你这个没去重复，也没按时间来筛选啊~

Answer 3

with tmp as(
(select dwid,CREATED,xdq,xde
from (select T.dwid,
T.CREATED,
xdq,xde
row_number() OVER(PARTITION BY T.dwid ORDER BY T.CREATED desc) RN
from A t)
where rn = 1)
)
select * from tmp

Answer 4

select a.*,b.xdq,xde from (select dwid,max(created)as created from A group by dwid)a
join A b on a.dwid=b.dwid