SQL Shortcuts
Boost your productivity with these essential SQL shortcuts.
| Shortcut | Description |
|---|---|
| SELECT | Retrieve data from a database |
| INSERT INTO | Insert new data into a table |
| UPDATE | Update existing data in a table |
| DELETE | Delete data from a table |
| CREATE TABLE | Create a new table in the database |
| ALTER TABLE | Modify an existing table |
| DROP TABLE | Delete a table from the database |
| WHERE | Filter records based on conditions |
| JOIN | Combine rows from two or more tables |
| GROUP BY | Group rows sharing a property |
| ORDER BY | Sort rows in a specific order |
| LIMIT | Specify the number of rows to return |
| DISTINCT | Return only unique rows |
| COUNT | Count the number of rows |
| AVG | Calculate the average value |
| SUM | Calculate the sum of values |
| MIN | Find the smallest value |
| MAX | Find the largest value |
| HAVING | Filter grouped data |
| UNION | Combine results of two queries |