How can I structure a mySQL query to delete a row based on the max value.
I tried
WHERE jobPositonId = max(jobPostionId)
but got an error?
DELETE FROM table ORDER BY jobPositonId DESC LIMIT 1
2.1m questions
2.1m answers
60 comments
57.0k users