subquery help

[beckwiga]

Hello TekTips .. been a while. I was hoping someone could help me with this query. I just need to return only the rows boxed in green. It's basically the most recent date ONLY for each suc_pic. I think I need a subquery I just don't know how to structure it or where to structure it. Any help is appreciated. Thanks in adavnce. beckwiga

http://i399.photobucket.com/albums/pp71/beckwiga/sql.png

 

[gmmastros]

try this:

Select Max(a.date_sk) as date_sk,
       a.suc_pic_sk
From   t_factless_pos_date a
Group By a.suc_pic_sk
Order By a.suc_pic_sk

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[beckwiga]

Perfect, that's just what I needed, thanks!