In this video lecture, we go ahead and look at the between keyword and PostgreSQL.
All right.
Let me go ahead and see that the time we did this, we actually created, uh, this date.
And the date is from 10th, um, fourth 20, 40 to 10 fourth, uh, 2050.
And now within this range, I want to pick maybe, uh, people who enrolled into this school, uh,
between 2041 or between 2049 to 2015, or between 2048 to 2049.
How do we do that?
So that is when we suddenly between keyword and right in here, I'll go ahead and see select all from
students.
And I'm going to give away our class.
So we are in real underscore date is between what I say is uh.
Between dates.
Then I'm going to specify because this is going to start from the year, let me say 2048.
All right.
So I'm going to start from 2048.
Then maybe ten zero one.
Then I'm going to say end.
And I want this to be uppercase.
And uh 2049 ten zero one.
So this is the range I want though I don't even know if this actually is seized, but I just want this
range.
Then let's go ahead and execute this query and check it out.
Wow.
That lottery exists.
So it can be able to see that we have this 24 to 8, 24, nine.
And, uh, we can see anything above 24 to 8 and 24 nine.
And if I should go ahead and reduce this to like a 24 to 8 from the first, the alternate 48 to maybe
30th or 20th.
And if I execute this query, the square.
Let's see.
We have 20 480 ten zero 924 eight Dow ten 1524 810 zero 724 eight 1020 and 24 to 810 zero one.
So in our way capabilities with the between keyword tool actually filter a range between maybe each.
We can maybe check people what between h this and h that.
You can also use that between Some students are ID some kind of see where students underscore ID so
stress underscore ID.
So I want to select all from students.
Where students are underscore ID is between.
Then I'm going to say maybe 500 and uh 550.
So this is a query.
And check it out.
So you can see I got that from 500 and down to 550.
So I'm taking this between a range.
And that is where the between keyword actually does for you.
So go ahead and check it out.
Practice with it.
And if you have any questions go ahead and use the question and answer section.
And I'm going to get back to you as soon as possible.
Thank you so much.
And I'm going to see you in the next video lecture.