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
SQL
x
1
SELECT column1, column2
2
FROM table_name;
3
4
SELECT *
5
FROM table_name;
6
7
DELETE
8
FROM table_name
9
WHERE condition;
SQL FROM with SELECT Columns Example
SQL
1
1
SELECT first_name, gender
2
FROM Patients;

SQL FROM with SELECT All Columns Example
SQL
1
1
SELECT *
2
FROM Doctors;

SQL FROM with DELETE Example
SQL
1
1
DELETE FROM Patients
2
WHERE last_name = 'Garcia';
