View Single Post
  #2 (permalink)  
Old July 27th, 2007, 03:57 PM
Peso Peso is offline
Friend of Wrox
 
Join Date: May 2006
Location: Helsingborg, , Sweden.
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT EventTime,
        Caption,
        Location,
        Message,
        OutageDurationInMinutes
FROM (
            <your query here without last order by>
        ) AS d
WHERE OutageDurationInMinutes >= 239
ORDER BY OutageDurationInMinutes