Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.65K
1 Posted Topic
SELECT (t1.log_id + 1) AS gap_starts_at, (SELECT MIN(t3.log_id) -1 FROM logtable t3 WHERE t3.log_id > t1.log_id) AS gap_ends_at FROM logtable t1 WHERE NOT EXISTS (SELECT t2.log_id FROM logtable t2 WHERE t2.log_id = t1.log_id + 1) HAVING gap_ends_at IS NOT NULL
The End.