 <p>I can't give you the syntax off the type of my head, but consider a subquery to get the most recent backup date and add this to your WHERE clause of the main query. Then you can loose the ORDER clause as you will get one result (and also loose the COUNT).</p>