1
00:00:00,330 --> 00:00:05,550
In this section, we're going to learn all about different ways of narrowing our selections or refining

2
00:00:05,550 --> 00:00:12,540
our selections, or at least manipulating them in some way to do things like order or sort our results,

3
00:00:12,870 --> 00:00:18,240
or only get unique or distinct results to limit the number of results we get.

4
00:00:18,240 --> 00:00:23,790
These are different things that we can add on to our queries to change how our selections behave.

5
00:00:23,970 --> 00:00:29,970
But before we do that, I would like for us to add a couple of new books to our books table so that

6
00:00:29,970 --> 00:00:31,980
we can have some clearer results.

7
00:00:31,980 --> 00:00:35,130
You'll see what I mean as we make some more progress in the section.

8
00:00:35,130 --> 00:00:39,810
But I would just copy and paste this or if you want to type it out yourself.

9
00:00:39,810 --> 00:00:41,580
But there's a couple of things I want to highlight.

10
00:00:41,580 --> 00:00:45,060
There's a percent sign here, so don't miss that.

11
00:00:45,480 --> 00:00:49,620
And then we've got two authors that have the same last name, but they're not the same author.

12
00:00:49,620 --> 00:00:54,450
One is Dan Harris, the other is free to Harris And just make sure you have the same numbers, the same

13
00:00:54,450 --> 00:00:55,590
text and all that stuff.

14
00:00:55,590 --> 00:01:00,810
Copy and paste this either from the slides or from the code following this video.

15
00:01:00,810 --> 00:01:04,080
And I'm going to make sure I'm using the right books database.

16
00:01:04,080 --> 00:01:06,360
So let's just do select database.

17
00:01:07,270 --> 00:01:10,750
Bookshop and I should have the books table still.

18
00:01:11,020 --> 00:01:13,090
Okay, I'll paste that and hit enter.

19
00:01:13,540 --> 00:01:15,850
We'll do a select star from books.

20
00:01:16,090 --> 00:01:21,850
And it's nasty to look at, but we see 10% happier fake book and Lincoln in the Bardo.

21
00:01:21,970 --> 00:01:22,630
Great.

22
00:01:22,660 --> 00:01:26,530
Next up, we're going to learn how to select distinct results.