There isn't an equivalent. You have to self-join back to the table to get the previous or next record. Be careful doing this as it will tend to create triangular joins.
Here is some useful information:
http://qa.sqlservercentral.com/articles/T-SQL/61539/[/url]