Gaps and islands problems involve finding a range of missing values (gaps) or a range of consecutive values (islands) in a sequence of numbers or dates.
I'm using SQL Server 2008 R2. I have table called EmployeeHistory with the following structure and sample data: EmployeeID Date DepartmentID …
sql sql-server sql-server-2008 row-number gaps-and-islandsUsing standard mysql functions is there a way to write a query that will return a list of days between …
mysql sql date gaps-and-islandsI have a column named sequence. The data in this column looks like 1, 2, 3, 4, 5, 7, 9, 10, 15. I need to find the missing sequence …
sql-server-2005 gaps-and-islandsI am doing a project creating an admission system for a college; the technologies are Java and Oracle. In one …
sql oracle plsql gaps-and-islandsWe have a database with a table whose values were imported from another system. There is an auto-increment column, and …
mysql sql gaps-and-islandsI'd like to find the first "gap" in a counter column in an SQL table. For example, if there are …
sql gaps-and-islandsI have a table with 2 columns, date and score. It has at most 30 entries, for each of the last 30 days …
mysql sql recursive-query gaps-and-islands date-arithmeticHow do you find the smallest unused number in a SQL Server column? I am about to import a large …
sql sql-server gaps-and-islandsI want to fill the calendar object which requires start and end date information. I have one column which contains …
sql sql-server sql-server-2008 gaps-and-islandsI have a database of users. I would like to create a graph based on userbase growth. The query I …
mysql date gaps-and-islands