I work on query to identify gaps/islands in ordered sequence of numbers in table. Of course there is lot of solutions for that problem but i am looking for most efficient way how to identify most recent gap. In other words just need to get top 1 island. Following works good (note that i haveRead more