Re: how to Replace subquery's with join(min,max)

[Thomas Wiedmann]

try this..

/* first */
SELECT t1.* 
  FROM table1 t1 
  JOIN ( SELECT MAX(t2.id) AS max_id FROM table1 t2 ) t2
    ON t1.id = t2.max_id;
    
/* second */
SELECT * FROM table1
ORDER BY id DESC
LIMIT 1;

with kind regards,
Thomas