All language subtitles for 7. SELECT statement

In the last video, we learned how to insert the data in our table using the insert into and copy command.

Now let us look at how to retrieve this data from the table.

That is how to get back the records present in the customer table.

The level of data from tables is done using the select command.

Select Command is used to fetch the data from database and the result table that you get is called result

sets.

The syntax for command is as follows.

We select.

Then mention the columns that we want to retrieve.

Then comes the key word from.

And then we mention the table name.

If you want to get all the columns and do not need to and do not want to specify any particular column

or columns, we will use a wild card.

Wild card is a special symbol.

Wild card for selecting all columns is an aesthetics sign.

So if we select aesthetics from table name, it will give us all the columns of that particular table.

Let us look at the examples.

So to retrieve only one column, for example, say if you want just the first name of all the customers

that you have in your customer table, this is the query you will write.

Select first name from Customer table.

Customer table is the table name.

Let us go to admin and run this command.

Select first name.

From the table, which is customer table.

Semicolon.

Select this query and turn it.

You can see the output below.

It has the.

It records and only the first name is fetched.

Now let us go back to the presentation.

If we want to get multiple columns.

So for example, if we now want both first name and last name for the customer, we will mention both

the column names.

So let's go and fetch.

First name and last name from the customer table.

First name.

Coma.

Last name?

From customer table.

But I need.

You can see now we have the first name and the last name.

Retrieved from the database for all the records.

If you remember, we discussed that aesthetics wild card can be used to get all the columns.

Let us use aesthetics while God.

So we'll write select.

Start.

From.

Customer table.

And you can guess it will give us all the columns of this table.

So.

Customer ID.

First name.

Last Name.

Age.

Email ID.

All the columns are retrieved for all the records.

So this is how using the select statement, we retrieve data from the table.

In the next lecture, we will see if there is duplicate entries in the table and we want to identify

only the unique values.

How do we retrieve unique data from a table?