How to identify sequenced record gaps by field on MySQL

Question

I can find sequenced record gaps where sequenced weeks with same numbers using following query.

SELECT * FROM pointed_numbers A WHERE EXISTS ( SELECT * FROM pointed_numbers B WHERE A.number = B.number AND (A.week = B.week + 1 XOR A.week = B.week - 1) ) ORDER BY A.number, A.week;

How can I identify each gaps without stored procedure. I have tried with user-defined variable but I had no success.

DWright · Accepted Answer · 2012-12-25 20:30:01Z

Take a look at http://www.artfulsoftware.com/infotree/queries.php and look at the stuff under the "sequences" section. This is a super super helpful site with recipes for how to do complicated things in mysql!

Collectives™ on Stack Overflow

How to identify sequenced record gaps by field on MySQL

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related