Search results
SQL Handwritten Notes Repository: A collection of PDF notes covering SQL concepts with concise definitions and examples. Explore fundamental commands, date/time functions, joins, and more. Contributions welcome!
1 cze 2021 · Standard SQL Functions Cheat Sheet. TEXT FUNCTIONS. CONCATENATION. Use the || operator to concatenate two strings: SELECT 'Hi ' || 'there!'; -- result: Hi there! Remember that you can concatenate only character strings using. ||. Use this trick for numbers: SELECT '' || 4 || 2;
Check the documentation for your specific database. LIKE OPERATOR – PATTERN MATCHING. Use the _ character to replace any single character. Use the % character to replace any number of characters (including 0 characters). Fetch all names that start with any letter followed by 'atherine': SELECT name. FROM names. WHERE name LIKE '_atherine';
2 wrz 2024 · In this guide, we will see a comprehensive cheat sheet for essential SQL operations, offering a practical reference for tasks ranging from database creation to advanced data handling techniques.
This 3-page SQL Cheat Sheet provides you with the most commonly used SQL statements. Download the SQL cheat sheet, print it out, and stick to your desk.
It starts from the absolute basics (SELECT * FROM table_name;) and guides you to the intermediate level (JOIN, HAVING, subqueries). I added everything that you will need as a data analyst/ scientist. The ideal use case of this cheat sheet is that you print it in color and keep it next to you while you are learning and practicing SQL on your ...
Using SQL, you are able to interact with the database by writing queries, which when executed, return any results which meet its criteria. Here’s an example query:-
