Select Row immediately previous and following a date range
630519Apr 23 2008 — edited Apr 24 2008I have a query which returns two values within a given date range (colA, colB). This works great. However, I also need to return (in a separate query) the entries immediately previous and following this current date range (same two values).
I am more familiar with MySQL where the query would include an "Order by date desc limit 1" for the row previous to the original query or "Order by date asc limit 1" for the row following the original query.
What is the best way to return these rows within Oracle?