SQL Language Elements

Retrieves rows from one or more tables.

SELECT column1, column2 FROM table_name WHERE condition;

Adds new rows to a table.

INSERT INTO table_name (column1, column2) VALUES (value1, value2);

Modifies existing rows in a table.

UPDATE table_name SET column1 = value1 WHERE condition;

Removes rows from a table.

DELETE FROM table_name WHERE condition;

Creates database objects such as tables, views, or procedures.

CREATE TABLE Employees (ID int, Name varchar(100));

Modifies existing database objects.

ALTER TABLE Employees ADD Salary decimal(10,2);

Deletes database objects.

DROP TABLE Employees;

Combines rows from two or more tables based on related columns.

SELECT * FROM Orders o JOIN Customers c ON o.CustomerID = c.ID;

Filters rows based on a condition.

SELECT * FROM Employees WHERE Salary > 50000;