Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pipeID and DateCCTV. A pipeID can be DateCCTV many times. I'd like
to get the most recent Date of the DateCCTV for each pipeID.
 
Tristan,

If all you are interested in is knowing the DateCCTV for each pipe then
something like this should work:

SELECT PipeID, MAX(DateCCTV) as MostRecentDate
FROM yourTable
GROUP BY PipeID

HTH
Dale
 
Back
Top