Forum Discussion
Solved
Is there an equivalent to a subquery
I am trying to create a report where I need to fetch the latest status from tracking table. I am trying to achieve something in the lines of
Select * from Table1
where trackdatetime in (select max(trackdatetime) from Table1 group by TrackID)
or
Select * from Table1 t1 inner join Table1 maxDate
Please see if this articles explains what you are trying to do.
Return Row Based on Max Value From One Column when Grouping — ehansalytics
Pat
1 Reply
Please see if this articles explains what you are trying to do.
Return Row Based on Max Value From One Column when Grouping — ehansalytics
Pat