如何用SQL 取最大的日期的记录？

0
如题：请教大神该怎么实现啊，小弟菜鸟 
7.jpg

 
2015-12-21 添加评论
分享

没有找到相关结果

    已邀请:
    0

    悟 - 取是能力，舍是境界 2015-12-21 回答 

    with A as
    
(
    
	select 'A' as Col1,20 as Col2
    
	union all
    
	select 'B',30
    
	union all
    
	select 'C',40
    
)
    
,B as
    
(
    
	select 'A' as Col1,20 as Col2,'2015-12-1' as Col3
    
	union all
    
	select 'B',30,'2015-12-1'
    
	union all
    
	select 'C',40,'2015-11-1'
    
	union all
    
	select 'A',10,'2015-10-1'
    
	union all
    
	select 'A',20,'2015-10-1'
    
)
    
select A.Col1,B.Col2,max(B.Col3) Col3
    
	from A
    
	join B on a.Col1 = b.Col1
    
	group by A.Col1,B.Col2
    
	order by A.Col1
    2015-12-21 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册