cheatsheet for sql

1Guys, are you looking for SQL cheatsheet, in pdf format :)
2 -> https://buggyprogrammer.com/sql-cheatsheet/

1# Finding Data Queries
2
3# SELECT: used to select data from a database
4SELECT * FROM table_name;
5
6# DISTINCT: filters away duplicate values and returns rows of specified column
7SELECT DISTINCT column_name;
8
9# WHERE: used to filter records/rows
10SELECT column1, column2 FROM table_name WHERE condition;
11SELECT * FROM table_name WHERE condition1 AND condition2;
12SELECT * FROM table_name WHERE condition1 OR condition2;
13SELECT * FROM table_name WHERE NOT condition;
14SELECT * FROM table_name WHERE condition1 AND (condition2 OR condition3);
15SELECT * FROM table_name WHERE EXISTS (SELECT column_name FROM table_name WHERE condition);
16
17# ORDER BY: used to sort the result-set in ascending or descending order
18SELECT * FROM table_name ORDER BY column;
19SELECT * FROM table_name ORDER BY column DESC;
20SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC;
21SELECT TOP: used to specify the number of records to return from top of table
22SELECT TOP number columns_names FROM table_name WHERE condition;
23SELECT TOP percent columns_names FROM table_name WHERE condition;
24
25# Not all database systems support SELECT TOP. The MySQL equivalent is the LIMIT clause
26SELECT column_names FROM table_name LIMIT offset, count;
27
28# LIKE: operator used in a WHERE clause to search for a specific pattern in a column
29# % (percent sign) is a wildcard character that represents zero, one, or multiple characters
30# _ (underscore) is a wildcard character that represents a single character
31SELECT column_names FROM table_name WHERE column_name LIKE pattern;
32
33LIKE ‘a%’ # (find any values that start with “a”)
34LIKE ‘%a’ # (find any values that end with “a”)
35LIKE ‘%or%’ # (find any values that have “or” in any position)
36LIKE ‘_r%’ # (find any values that have “r” in the second position)
37LIKE ‘a_%_%’ # (find any values that start with “a” and are at least 3 characters in length)
38LIKE ‘[a-c]%’ # (find any values starting with “a”, “b”, or “c”
39
40# See more in the source link