WEBVTT

00:07.490 --> 00:13.370
In this video lecture, we go ahead and look at the between keyword and PostgreSQL.

00:13.880 --> 00:14.300
All right.

00:14.330 --> 00:21.950
Let me go ahead and see that the time we did this, we actually created, uh, this date.

00:21.950 --> 00:30.320
And the date is from 10th, um, fourth 20, 40 to 10 fourth, uh, 2050.

00:30.350 --> 00:39.170
And now within this range, I want to pick maybe, uh, people who enrolled into this school, uh,

00:39.200 --> 00:50.690
between 2041 or between 2049 to 2015, or between 2048 to 2049.

00:50.930 --> 00:52.370
How do we do that?

00:52.400 --> 00:58.490
So that is when we suddenly between keyword and right in here, I'll go ahead and see select all from

00:58.490 --> 00:59.420
students.

00:59.420 --> 01:02.140
And I'm going to give away our class.

01:02.140 --> 01:12.370
So we are in real underscore date is between what I say is uh.

01:14.590 --> 01:17.680
Between dates.

01:17.710 --> 01:26.950
Then I'm going to specify because this is going to start from the year, let me say 2048.

01:26.980 --> 01:27.670
All right.

01:27.670 --> 01:30.340
So I'm going to start from 2048.

01:30.370 --> 01:33.460
Then maybe ten zero one.

01:33.850 --> 01:36.580
Then I'm going to say end.

01:36.610 --> 01:39.040
And I want this to be uppercase.

01:39.070 --> 01:46.030
And uh 2049 ten zero one.

01:46.030 --> 01:51.280
So this is the range I want though I don't even know if this actually is seized, but I just want this

01:51.280 --> 01:52.060
range.

01:52.270 --> 01:55.300
Then let's go ahead and execute this query and check it out.

01:55.330 --> 01:56.020
Wow.

01:56.050 --> 01:57.640
That lottery exists.

01:57.640 --> 02:05.830
So it can be able to see that we have this 24 to 8, 24, nine.

02:05.920 --> 02:11.380
And, uh, we can see anything above 24 to 8 and 24 nine.

02:11.380 --> 02:19.810
And if I should go ahead and reduce this to like a 24 to 8 from the first, the alternate 48 to maybe

02:19.840 --> 02:22.330
30th or 20th.

02:22.330 --> 02:24.670
And if I execute this query, the square.

02:24.670 --> 02:25.180
Let's see.

02:25.210 --> 02:41.440
We have 20 480 ten zero 924 eight Dow ten 1524 810 zero 724 eight 1020 and 24 to 810 zero one.

02:42.130 --> 02:51.130
So in our way capabilities with the between keyword tool actually filter a range between maybe each.

02:51.160 --> 02:56.380
We can maybe check people what between h this and h that.

02:56.410 --> 03:07.510
You can also use that between Some students are ID some kind of see where students underscore ID so

03:08.290 --> 03:10.990
stress underscore ID.

03:11.440 --> 03:13.150
So I want to select all from students.

03:13.150 --> 03:16.570
Where students are underscore ID is between.

03:16.600 --> 03:24.280
Then I'm going to say maybe 500 and uh 550.

03:24.310 --> 03:26.080
So this is a query.

03:26.080 --> 03:27.070
And check it out.

03:27.070 --> 03:32.590
So you can see I got that from 500 and down to 550.

03:32.590 --> 03:35.860
So I'm taking this between a range.

03:35.860 --> 03:39.130
And that is where the between keyword actually does for you.

03:39.130 --> 03:40.510
So go ahead and check it out.

03:40.540 --> 03:41.290
Practice with it.

03:41.290 --> 03:45.250
And if you have any questions go ahead and use the question and answer section.

03:45.280 --> 03:48.160
And I'm going to get back to you as soon as possible.

03:48.190 --> 03:49.210
Thank you so much.

03:49.210 --> 03:52.450
And I'm going to see you in the next video lecture.