Earliest date of the latest ID

Moderator: NorbertKrupa

Post Reply
Posts: 12
Joined: Sat May 26, 2012 3:26 pm

Earliest date of the latest ID

Post by dazz » Thu Jul 20, 2017 5:58 pm


I am trying to get the earliest start time of the latest plan that the person took. In the following, the latest plan is P1, and the earliest start date of it is 06-Feb-2015 . It should therefore return P1 , 06-Feb-2015

ID Date Plan Bundle
100 03-Jan-2014 P1 12
100 13-Oct-2014 P2 07
100 21-Dec-2014 P2 09
100 06-Feb-2015 P1 11
100 06-Nov-2015 P1 13
100 18-Apr-2016 P1 14

Ive tried a few ways to get it, but Im not getting thru. Appreciate any assistance pleaseee


User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

Re: Earliest date of the latest ID

Post by JimKnicely » Thu Jul 20, 2017 7:00 pm

Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica SQL”