FROM

The FROM clause is employed to indicate the table from which data is to be selected or deleted. The subsequent SQL statement retrieves the “CustomerName” and “City” columns from the “Customers” table:

Example

SELECT CustomerName, City FROM Customers;

The subsequent SQL statement retrieves all columns from the “Customers” table:

Example

SELECT * FROM Customers;

The following SQL statement removes the customer “Alfreds Futterkiste” from the “Customers” table:

Example

DELETE FROM Customers
WHERE CustomerName=‘Alfreds Futterkiste’;