SQL SELECT Statement

SQL Tutorial » SQL SELECT Statement

What is SELECT * from in SQL?

SQL SELECT statement is used to select any data from a database.
The data returned (displayed) is stored in a result table, called the result-set.

Syntax:

column_name1, column_name2, ... are the field names of the table_name you want to select data from.
To select all the fields available in the table_name, you have to use the following syntax:

Let's look at the "Order_details" table: We will have seven columns as: "id", "first_name", "last_name", "country", "city", "product_id"and "quantity":

Let's look at the "Order_details" table: We will have seven columns as: "id", "first_name", "last_name", "country", "city", "product_id"and "quantity":

The following SQL statement selects the "CustomerName" and "City" columns from the "Customers" table:

Display out: Number of Records: 5

Related subjects:
SQL order by SQL where clause PHP select / view data Conect to MySQLi SQL insert into table

Tags: sql select: from multiple tables, as, synrax, distinct, count, group by, sort, top, like, into
What is SELECT * from in SQL?
What is a SELECT list SQL?
How do I SELECT specific rows in SQL?
How do you query in SQL?

The following SQL SELECT statement all the columns from the "Order_details" table:

How do you SELECT multiple tables in a query?
How can I get data from three tables in a single query?

We have three database as: country, products, customer