Dates

T

Tristan

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.
 
D

Dale Fye

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
 
Top