Suppose you want to select records from a table (say orders from a Northwind database), before and after a certain value (
orderid). For instance, one order before and after
10250. You'd write a query like this:
SELECT TOP 3* FROM orders
WHERE OrderId >=(SELECT MAX(OrderId) FROM orders WHERE OrderId < 10250)
ORDER BY OrderId
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
