Is there an equivalent to a subquery

[jashjacob]

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

[mahoneypat · Accepted solution]

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