Actually the one suggested by Sergey in message#
1133767 is different from mine. His one is faster and better because it gets the resulting records directly from the subquery result without running the "IN" filtering operation against the master table.
Ben
>>
>>SELECT Streaming FORM Video Where Streaming IN (SELECT TOP 5 Streaming FROM Video ORDER BY Streaming DESC) ORDER BY Streaming
>>
>
>Thanks, this seems to work very well.