# Finding Data Queries</p> <p># SELECT: used to select data from a database<br /> SELECT * FROM table_name;</p> <p># DISTINCT: filters away duplicate values and returns rows of specified column<br /> SELECT DISTINCT column_name;</p> <p># WHERE: used to filter records/rows<br /> SELECT column1, column2 FROM table_name WHERE condition;<br /> SELECT * FROM table_name WHERE condition1 AND condition2;<br /> SELECT * FROM table_name WHERE condition1 OR condition2;<br /> SELECT * FROM table_name WHERE NOT condition;<br /> SELECT * FROM table_name WHERE condition1 AND (condition2 OR condition3);<br /> SELECT * FROM table_name WHERE EXISTS (SELECT column_name FROM table_name WHERE condition);</p> <p># ORDER BY: used to sort the result-set in ascending or descending order<br /> SELECT * FROM table_name ORDER BY column;<br /> SELECT * FROM table_name ORDER BY column DESC;<br /> SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC;<br /> SELECT TOP: used to specify the number of records to return from top of table<br /> SELECT TOP number columns_names FROM table_name WHERE condition;<br /> SELECT TOP percent columns_names FROM table_name WHERE condition;</p> <p># Not all database systems support SELECT TOP. The MySQL equivalent is the LIMIT clause<br /> SELECT column_names FROM table_name LIMIT offset, count;</p> <p># LIKE: operator used in a WHERE clause to search for a specific pattern in a column<br /> # % (percent sign) is a wildcard character that represents zero, one, or multiple characters<br /> # _ (underscore) is a wildcard character that represents a single character<br /> SELECT column_names FROM table_name WHERE column_name LIKE pattern;</p> <p>LIKE ‘a%’ # (find any values that start with “a”)<br /> LIKE ‘%a’ # (find any values that end with “a”)<br /> LIKE ‘%or%’ # (find any values that have “or” in any position)<br /> LIKE ‘_r%’ # (find any values that have “r” in the second position)<br /> LIKE ‘a_%_%’ # (find any values that start with “a” and are at least 3 characters in length)<br /> LIKE ‘[a-c]%’ # (find any values starting with “a”, “b”, or “c”</p> <p># See more in the source link

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

BEST PDF SQL CHEATSHEET please upvote :’) ‘<br /> https://learnsql.com/blog/sql-basics-cheat-sheet/sql-basics-cheat-sheet-letter.pdf