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;

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;

SELECT first_name, gender

FROM Patients;

SQL FROM with SELECT All Columns Example

SELECT *
FROM Doctors;

SELECT *

FROM Doctors;

SQL FROM with DELETE Example

DELETE FROM Patients
WHERE last_name = 'Garcia';

DELETE FROM Patients

WHERE last_name = 'Garcia';

SQL FROM Labs