12 Oct 2023 Dominika Florczykowska What Does ORDER BY 1 Mean in SQL? Have you ever seen the "ORDER BY 1" syntax in SQL queries and wondered what it means? In this article, we'll explore this syntax, clarify its purpose, and make it easier to grasp. Whether you're an experienced SQL user or just starting to explore this language, you've likely encountered the ORDER BY clause before. In SQL, the ORDER BY clause is used to sort the rows in a table based on one or more columns. Read more 8 Aug 2023 Dominika Florczykowska What Does GROUP BY 1 and GROUP BY 1, 2, 3 Mean in SQL? Have you ever come across the unfamiliar GROUP BY 1 syntax in SQL queries and wondered what it's all about? Well, you're not alone! In this article, we'll dive into this syntax, explain its purpose, and make it easier to understand. Whether you are a regular SQL user or you’re just beginning to learn this language, you have probably worked with GROUP BY before. The GROUP BY clause in SQL is used to group rows from a table based on one or more columns. Read more 15 Jun 2023 Dominika Florczykowska An Overview of MySQL Window Functions MySQL window functions are very helpful when you want to create meaningful reports with SQL. In this article, we’ll demonstrate the most common window functions in MySQL and explain how to use them. MySQL 8.0 introduced a new feature: window functions. These functions are very useful to data analysts and anyone who creates reports using MySQL. Using them, you can easily compute moving averages, cumulative sums, and other calculations over specified subsets of your data. Read more 4 May 2023 Dominika Florczykowska How to Write Multiple Joins in One SQL Query Have you ever wondered how multiple joins work? Want to know how to join multiple tables in one query? Read this article to find out! If you are just beginning your SQL journey, you may have found it difficult to understand the concept of SQL JOINs, especially if you have to join more than two tables in one query. Worry not! In this article, we will explore how JOIN works and solve all its mysteries! Read more 20 Oct 2022 Dominika Florczykowska What Does a Double Colon Operator in PostgreSQL Do? The double colon operator :: in PostgreSQL is a synonym for CAST, which converts a value into a different data type. If you are curious about the details , read on! Have you ever seen a double colon (::) operator in someone’s PostgreSQL code? It would look something like this: SELECT '2022-09-02'::date; This code converts the text '2022-09-02' to a date datatype. As mentioned above, the double colon replaces the CAST operator. Read more 22 Feb 2022 Dominika Florczykowska An Overview of MySQL Data Types What data types are available in a MySQL database? In this article, you’ll learn about numeric data types, text data types, and much more! You may have seen our article about data types in SQL. Here, we focus on the MySQL data types. We will discuss the most commonly used ones: numeric, text, and date and time. If you are interested in the topic, be sure to check out our Data Types in SQL course. Read more