Original subtitles

I great you Once again, we're going to show you how to select. We're going to learn the select statement

We goping to see how we can select data in the database as we created a database, we created tables, then we

need to see how to retrieve the data, how to see data from database.

How we are going to get that data from database

So we're going to use the statement called Select.

We're going to see many types of selection.

But I'm going to show you an example of what we're going to do.

It's a point of sale, as I told you.

I'm going to show you why we click on Beverage and we get like, non alcohol.

When we click on the button food, we get like a small food, like pizza.

We get like seafood.

We get gasby... why and how we get those kind of beverage?

Why by clicking some place, we get more options.

All of that it is because of the selection statement.

We are selecting things from the database.

It's that we are going to show you how to do selection of things. ==> write Select

Star then From, then the name of the table.

That command will show you all data which is at the table.

Let's write it. Right-click on the table, then you click select, for example.

Select top 1000, it will show you all the data which is in the database.

But the top 1000.

We don't need to write like top 1000.

We can do it in our own way, it means all the data which is in the database, not only like the way

it's written, like the automatic query which is given by the system.

We can write our own statement so we can write like select staff from table name.

Then we will get all data which is in that table.

Let let me show you the data which is in the table.

We need to make sure there is no space between.

So we write select, space, from, then the database name and the table name.

If you click execute, it will show you all data which is in the database, like here you can see we have

first button.

It shows Beverage, it shows food, wine.

All of this is like what I showed you in buttons

What showed you in buttons in the database, when I click on "Make Order", when I click on "Beverage",

it shows me all the beverage we have.

If I click on "food", it shows me all the categories of food we have.

If I click on "wine", it shows me all wines we have.

That is a selection option we are using.

Right-click

on the table, then you click on Select like top thousand or edit 200 rows.

I told you, you can add more data, and also

It helps you to see or to show the data you have in the database.

You can edit it from there, you can add data from there and you can select also from that command.

It's the command select all from the database.

But there are many command you can use to select data from the database, which we are going to see.

For example, there is a command: select all from the table where...

For example, when I click like beverage, I select All from the Table where the name of the column

is Beverage.

I'm going to show it in detail, in more detailS, because we have a lot of things which talk about selection.

I'm going to show you how to do selection.

Select all from table name, you write for example: select star from first category menu,

this command will show you all first category, menu items which are saved in the table

It will show you all of that, we can select by specifying what we going to select in the database.

For example, here in the table, third category menu, we're going to select only quantity price and

the third button menu.

It's another culomn which is in the category menu table.

We can say for example let me select only the quantity, price, the button menu where second button menu equal,

for example: "beverage".

Then it will give you all price, quantity, all third button menu where the second button menu equal

food, wine, things like that.

That's why you could see when I click on the button, it gives sub menu

sub items which are in that menu, or from table or you can select all from the table where there

is a condition.

Now you can see you can select a specific item in the table.

And also there is another one, another statement which is: select top price from the third category

menu.

It means you only select the top price from the third category menu, It means which is a high price.

You can also do that selection.

We're going to see many selection because we are going to learn about views and

We are going see

We're going to talk a lot about selection in views.

View is only selection statement.

It's only showing data from the database.

So we're going to talk a lot in views in the select statement.

I'm going to talk a lot about selection.

I thank you so much for your attention and I hope you are enjoying this course.

Remember to rate our course and to rwite a comment so we can know how to improve this course.

I thank you once again.

And see you on the next lecture.