Unable to get Last Record..

[Julianna Fruin]

I am trying to get the last record with the latest timestamp on dd_acquired_ts so that I can plug that value in to UPDTAE statement, but max (d.dd_acquired_ts), top 1 (d.dd_acquired_ts) returns an error. Please advise me on how to get the last / max record off of:

SELECT max (d.dd_acquired_ts)
FROM tdds.discrete_data d
where d.dd_acquired_ts < 1493152486000
ORDER BY d.dd_acquired_ts asc
LIMIT 100000


// 'innodb_version', '1.1.8'

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