Get query to return the most recent results for each process

Hey everyone I’m executing this query. How do i get the query to return the most recent result?

"select distinct (process_name)

,means

,hyper

, Time_Stamp

from dataanalysis.dbo.bpa_process_logging

where means =‘T’

and hyper = ‘F’

@seanp92

You can add

ORDER BY timestamp ASC

Hope this helps you

Thanks

1 Like