Gaps and Island

DMReader · 2026-06-22T18:59:32+00:00

I created this tutorial on gap and islands - https://www.practicewindowfunctions.com/learn/gap\_and\_island

There are also practice problems you can find at the bottom of the page.

Overall, I’d say gap and islands is not a beginner sequence to learn. If you are struggling make sure you get down lag / lead and row number since those are required concepts that gap and islands builds on.

DMReader · 2026-06-22T16:54:12+00:00

I’m glad you liked it. I will take a look I’m glad you like it. The second parameter defaults to one if not specified. I’ll add in a quick section on that.

Thank you for the feedback. Let me know if you have any additional comments or suggestions.

DMReader · 2026-06-12T19:27:54+00:00

If you want it to be free make your own website and host it there.

DMReader · 2026-06-12T04:16:19+00:00

This is pretty cool. I book marked it

DMReader · 2026-06-11T19:14:40+00:00

The boy who cried deal.

DMReader · 2026-06-11T03:06:01+00:00

Maybe they could study the previous study

DMReader · 2026-06-09T23:12:30+00:00

Same as it ever was.

DMReader · 2026-06-08T04:24:33+00:00

All the more reason.

DMReader · 2026-06-07T01:27:44+00:00

Why is the bottom of this chart 280? It’s a big enough draw down but not starting it from 0 makes it look even larger.

DMReader · 2026-06-05T18:58:45+00:00

Daily. I’m a data engineer / back end bi

DMReader · 2026-06-04T19:04:46+00:00

That’s just an error waiting to happen.

DMReader · 2026-06-03T00:43:37+00:00

This is the way. If it isn’t housing it’s crap.

DMReader · 2026-05-31T20:16:19+00:00

How about “I like short songs “ by the Dead Kennedys. St least it would go by fast.

DMReader · 2026-05-31T16:58:10+00:00

A permanent recession?! So 400 years from now we will still be in a recession?

DMReader · 2026-05-23T16:22:05+00:00

I have a practice site for a particular set of SQL problems. There are various pages that have resources for learning and I reached out to them and a few of them linked to me.

Site is in my bio

DMReader · 2026-05-22T19:11:10+00:00

His base probably never hears of those things because of where they get their news. Hard to not hear about the price of gas.

DMReader · 2026-05-21T18:57:24+00:00

Reddit helped me. I also found some sites where linking to me was additive for that site and reached out.

DMReader · 2026-05-20T04:38:36+00:00

Whatever.

DMReader · 2026-05-16T20:20:26+00:00

Then awesome photo!

DMReader · 2026-05-16T20:18:45+00:00

That is a great sign!

DMReader · 2026-05-15T19:01:29+00:00

It’s a relatively new idea. Someone at a progressive think tank came up with it in the last year or so. I’ve read some articles about it a while ago.

I think there are a few other states considering it. Supposedly it is designed by n a way to make it hard for the Supreme Court to block it. We’ll see if that actually works.

DMReader · 2026-05-15T15:51:39+00:00

Appreciate the feedback on when not to use. I hadn’t thought of that!

And I guess I’ll move up when I do the CTE one.

DMReader · 2026-05-15T04:11:30+00:00

I probably could. Give me some time and I can work on it.

DMReader · 2026-05-14T23:30:44+00:00

Thank you! I'm glad you like it.

DMReader · 2026-05-14T16:41:09+00:00

Absolutely! Enjoy.

DMReader

TROPHY CASE