Search results
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; -- result: 42.
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;
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 ...
Example: Returns users and their subscriptions, along with a new column called activity_levels that makes a judgement based on the number of subscriptions. SELECT first_name, surname, subscriptions CASE WHEN subscriptions > 10 THEN 'Very active' WHEN Quantity BETWEEN 3 AND 10 THEN 'Active' ELSE 'Inactive' END AS activity_levels FROM users; CHECK
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.
SQL Cheat Sheet: Fundamentals. Performing calculations with SQL. Performing a single calculation: SELECT 1320+17; Performing multiple calculations: SELECT 1320+17, 1340-3, 7*191, 8022/6; Performing calculations with multiple numbers: SELECT 1*2*3, 1+2+3; Renaming results: SELECT 2*3 AS mult, 1+2+3 AS nice_sum; Selecting tables, columns, and rows:
