KEMBAR78
SQL Queries CheatSheet v2 | PDF | Computing | Computer Programming
Scribd
Upload
5 views2 pages

SQL Queries CheatSheet v2

The document is a SQL Queries Cheat Sheet that provides a list of common SQL tasks along with their corresponding queries and use cases. It covers various operations such as selecting data, filtering, joining tables, grouping, and modifying records. Each task is succinctly described to aid users in quickly referencing SQL commands for different scenarios.

Uploaded by

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

SQL Queries CheatSheet v2

The document is a SQL Queries Cheat Sheet that provides a list of common SQL tasks along with their corresponding queries and use cases. It covers various operations such as selecting data, filtering, joining tables, grouping, and modifying records. Each task is succinctly described to aid users in quickly referencing SQL commands for different scenarios.

Uploaded by

Surya S
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SQL Queries Cheat Sheet

Task Query Use Case


Show all data SELECT * FROM employees; Full table view
Filter rows SELECT * FROM employees WHERE age > 30; Apply conditions
Comparison ops SELECT * FROM employees WHERE salary >= 50000; Greater / less check
Multiple cond. SELECT * FROM employees WHERE dept='IT' AND age < 40; Combine conditions
Sort results SELECT * FROM employees ORDER BY salary DESC; Highest first
Limit rows SELECT * FROM employees LIMIT 5; Show top 5
Unique values SELECT DISTINCT department FROM employees; Remove duplicates
Pattern match SELECT * FROM employees WHERE name LIKE 'A%'; Names starting with A
Null check SELECT * FROM employees WHERE email IS NULL; Missing values
Date filter SELECT * FROM orders WHERE order_date BETWEEN Filter by date
'2024-01-01' AND '2024-12-31';

Inner join SELECT * FROM orders JOIN customers ON Merge related data
orders.cid=customers.id;

Left join SELECT * FROM customers LEFT JOIN orders ON Show all customers
customers.id=orders.cid;

Group & Sum SELECT dept, SUM(salary) FROM employees GROUP BY dept; Dept totals
Group & Avg SELECT dept, AVG(salary) FROM employees GROUP BY dept; Avg salary by dept
Having clause SELECT dept, COUNT(*) FROM employees GROUP BY dept Groups filter
HAVING COUNT(*) > 5;

Aliases SELECT name AS Employee, salary AS Pay FROM employees; Rename


Task Query Use Case
Top N values SELECT * FROM employees ORDER BY salary DESC LIMIT 3; Top 3 earners
Subquery SELECT name FROM employees WHERE salary > (SELECT Above avg salary
AVG(salary) FROM employees);

Case/if SELECT name, CASE WHEN salary > 50000 THEN 'High' Categorize
ELSE 'Low' END AS Level FROM employees;

Insert INSERT INTO employees (name, age, dept) VALUES Add data
('Asha', 28, 'HR');

Update UPDATE employees SET salary = salary * 1.1 WHERE Raise salaries
dept='IT';

Delete row DELETE FROM employees WHERE id=101; Remove record


Drop table DROP TABLE employees; Delete table
Create view CREATE VIEW high_salary AS SELECT * FROM employees Virtual table
WHERE salary>60000;

Create index CREATE INDEX idx_salary ON employees(salary); Faster queries

You might also like