Thread
:
How do I select the highest 20 to 30 values?
View Single Post
#
5
(
permalink
)
01-18-2008, 10:56 AM
Unregistered
Posts: n/a
ANY
answer.
Re: How do I select the highest 20 to 30 values?
SELECT TOP (10) ShippingId
FROM Shipping
WHERE (ShippingId NOT IN
(SELECT TOP (20) ShippingId
FROM Shipping AS Shipping_1
ORDER BY ShippingId DESC))
ORDER BY ShippingId DESC
Unregistered
ANY