FROM

SQL FROM Keyword

The FROM clause is used to specify the table from which to retrieve or delete data. It is required in SELECT and DELETE statements and helps define the data source for the query.

SQL FROM Keyword Syntax

SELECT column1, column2
FROM table_name;

SELECT *
FROM table_name;

DELETE
FROM table_name
WHERE condition;

SQL FROM with SELECT Columns Example

SELECT first_name, gender
FROM Patients;

SQL FROM with SELECT All Columns Example

SELECT *
FROM Doctors;

SQL FROM with DELETE Example

DELETE FROM Patients
WHERE last_name = 'Garcia';

SQL FROM Labs