Re: Unable to get Last Record..

[Peter Brawley]

Top 1 isn't MySQL syntax.

Your query without the Order By and Limit clauses will return the specified max.

So the update cmd would be ...

update tdds.discrete_data d 
set d.dd_auto_purge=1 
where d.dd_acquired_ts < (
  SELECT Max(dd_acquired_ts) 
  FROM tdds.discrete_data 
  where dd_acquired_ts < 1493152486000 
)
ORDER BY d.dd_acquired_ts asc 
LIMIT 100000;