according to Ben-Gan’s book, the TOP clause occurs earlier in the logical processing order than the ORDER BY clause. But the former requires the order sorted by the latter to function. Doesn’t this contradict the idea of ‘logical processing order’?
according to Ben-Gan’s book, the TOP clause occurs earlier in the logical processing order than the ORDER BY clause. But the former requires the order sorted by the latter to function. Doesn’t this contradict the idea of ‘logical processing order’?