Timeline for Find "n" consecutive free numbers from table
Current License: CC BY-SA 3.0
7 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Mar 19, 2013 at 7:01 | comment | added | Ununoctium | Well I didn't want to rely on window functions and gave a solution that would work on any sql-db. | |
Mar 19, 2013 at 6:59 | history | edited | Ununoctium | CC BY-SA 3.0 |
Added another version with joins instead of where clauses
|
Mar 18, 2013 at 17:25 | review | First posts | |||
Mar 18, 2013 at 17:45 | |||||
Mar 18, 2013 at 17:22 | comment | added | JNK |
Alternatively can you write it with modern JOIN syntax?
|
|
Mar 18, 2013 at 17:12 | comment | added | JNK | You think a 4-way cartesian product is an efficient way to do this? | |
Mar 18, 2013 at 17:12 | history | edited | JNK | CC BY-SA 3.0 |
added 8 characters in body
|
Mar 18, 2013 at 17:09 | history | answered | Ununoctium | CC BY-SA 3.0 |