Scribd
Upload
4 views3 pages

SQL Query Cheatsheet

The document is a SQL Query Cheatsheet that provides essential commands for Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Data Control Language (DCL), and Transaction Control Language (TCL). It includes syntax for creating, altering, and dropping tables and views, as well as inserting, updating, deleting, and querying data. Additionally, it covers permissions management and transaction control commands.

Uploaded by

Wadeed Khan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views3 pages

SQL Query Cheatsheet

The document is a SQL Query Cheatsheet that provides essential commands for Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Data Control Language (DCL), and Transaction Control Language (TCL). It includes syntax for creating, altering, and dropping tables and views, as well as inserting, updating, deleting, and querying data. Additionally, it covers permissions management and transaction control commands.

Uploaded by

Wadeed Khan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL Query Cheatsheet

Data Definition Language (DDL)

Create Table
CREATE TABLE table_name (
column1 datatype constraints,
column2 datatype constraints,
PRIMARY KEY (column_name)
);

Alter Table
ALTER TABLE table_name ADD column_name datatype;
ALTER TABLE table_name DROP COLUMN column_name;
ALTER TABLE table_name MODIFY column_name datatype;

Drop Table
DROP TABLE table_name;

Create View
CREATE VIEW view_name AS
SELECT column1, column2 FROM table_name WHERE condition;

Drop View
DROP VIEW view_name;

Data Manipulation Language (DML)

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

Insert Data from Another Table


INSERT INTO table_name (column1, column2)
SELECT column1, column2 FROM another_table WHERE condition;

Update Data
UPDATE table_name SET column1 = value1 WHERE condition;

Delete Data
DELETE FROM table_name WHERE condition;

Data Query Language (DQL)

Basic Select Query


SELECT column1, column2 FROM table_name WHERE condition;
Filtering Data
SELECT * FROM table_name WHERE column_name = 'value';

Sorting Data
SELECT * FROM table_name ORDER BY column_name ASC|DESC;

Pattern Matching
SELECT * FROM table_name WHERE column_name LIKE 'pattern%';

Using BETWEEN
SELECT * FROM table_name WHERE column_name BETWEEN value1 AND value2;

Using IN
SELECT * FROM table_name WHERE column_name IN (value1, value2, value3);

Aggregations
SELECT COUNT(column_name), SUM(column_name), AVG(column_name),
MIN(column_name), MAX(column_name) FROM table_name;

Group By and Having


SELECT column_name, COUNT(*) FROM table_name
GROUP BY column_name HAVING COUNT(*) > value;

Joins
INNER JOIN: Returns only matching records.
LEFT JOIN: Returns all records from the left table, matched records from the right.
RIGHT JOIN: Returns all records from the right table, matched records from the left.
FULL JOIN: Returns all records from both tables.

SELECT a.column1, b.column2 FROM table1 a


INNER JOIN table2 b ON a.common_field = b.common_field;

Set Operations
SELECT column_name FROM table1 UNION SELECT column_name FROM table2;

Data Control Language (DCL)

Grant Permissions
GRANT SELECT, INSERT ON table_name TO user_name;

Revoke Permissions
REVOKE SELECT, INSERT ON table_name FROM user_name;

Transaction Control Language (TCL)

Commit Transaction
COMMIT;
Rollback Transaction
ROLLBACK;

Savepoint
SAVEPOINT savepoint_name;

You might also like