Execute query that normally runs on a single ID for every ID

Question

Damien.Bell’s Question:

So I have this query:

SELECT     ABS(TIMESTAMPDIFF(MINUTE, NOW(), 
(SELECT    MAX(`Time`) 
FROM       ddHistorical 
WHERE      ID = '5')))

I want to run that on every ID in my database, how would I do that?

Answer 1

Just remove the WHERE part, it will run on every rows.

SELECT ABS(TIMESTAMPDIFF(MINUTE, NOW(), (SELECT MAX(`Time`) FROM ddHistorical