Text copied!
FROM clause
SQL clause is the specific part of a SQL statement which is used to perform various operations. It can be combined to create more complex queries to retrieve and manipulate data.
FROM clause :
FROM clause is used to specify table name(s) from where data will be retrieved. It is often used with other clauses such as 'SELECT', 'WHERE' and 'ORDER BY' etc. to retrieve, filter, sort and manipulate data.
The syntax of the FROM clause generally looks like this :
SELECT column_name(s)
FROM table_name;
• Specify the column(s) name after the 'SELECT' keyword.
• Specify Asterisk (*) symbol to selects all columns from the table after the 'SELECT' keyword.
• Specify the table name after the 'FROM' keyword.
Here's an example of how you might use the FROM clause :
1. Suppose we have two tables, namely the [Product] table and the [Employees] table.
2. Let's retrieve all columns and rows from the [Product] table >> Run below SQL statement :
SELECT *
FROM [Product];
3. Above statement will select all the data from the [Product] table.
4. Now, let's retrieve all columns and rows from the [Employees] table >> Run below SQL statement :
SELECT *
FROM [Employees];
5. Above statement will select all the data from the [Employees] table.
That's it! You have successfully retrieved all data from [Product] and [Employees] table.