select top 1 OrderID from (select top 2 OrderID from
T_orderheader order by OrderID desc)
order by OrderID asc
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
Open in new window