{"id":170263,"date":"2023-09-09T07:17:42","date_gmt":"2023-09-09T06:17:42","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=170263"},"modified":"2023-10-30T19:52:14","modified_gmt":"2023-10-30T18:52:14","slug":"sql-tutorial-top-5-most-useful-methods","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods","title":{"rendered":"SQL Tutorial: Top 5 Most Useful Methods"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"170263\" class=\"elementor elementor-170263\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2780b239 e-flex e-con-boxed e-con\" data-id=\"2780b239\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-414de7b5 elementor-widget elementor-widget-text-editor\" data-id=\"414de7b5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">SQL Tutorial: <a href=\"https:\/\/datascientest.com\/en\/sql-learn-all-about-the-programming-language-for-databases\">SQL, or Structured Query Language<\/a>, is a programming language that is nearly indispensable for managing databases in today&#8217;s data-driven world. <\/p><p>In a world where data is a valuable resource in its own right, it&#8217;s easy to understand why knowing how to use this language is a highly sought-after skill.<\/p><p>In this article, we will briefly introduce how this language works and then delve into the 5 methods you need to know to get started with SQL. Let&#8217;s embark on this <a href=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\">SQL Tutorial!<\/a><\/p><p>\ud83d\udca1 Read also:<\/p><ul><li><a href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\">Power BI Direct Query<\/a><\/li><li><a href=\"https:\/\/datascientest.com\/en\/data-scientist-job-all-about\">Data Scientists &#8211; What do they do?<\/a><\/li><li><a href=\"https:\/\/datascientest.com\/en\/mongodb-all-about-the-document-oriented-nosql-database\">MongoDB &#8211; Everything about this noSQL Database<\/a><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-36d677ec e-flex e-con-boxed e-con\" data-id=\"36d677ec\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3e851ce2 elementor-widget elementor-widget-heading\" data-id=\"3e851ce2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">1) SQL Tutorial: How SQL works<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46449a7f elementor-widget elementor-widget-text-editor\" data-id=\"46449a7f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The main advantage of <a href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\">SQL<\/a>, and probably the reason for its success, is the simplicity of its syntax. While many languages come with strict indentation, specialized vocabulary, and long lines of code, <strong>SQL<\/strong> offers methods that fit on a single line and resemble everyday language.<\/p><p>For example: SELECT Name FROM Clients<\/p><p>Literally means &#8220;Select names from Clients.&#8221;<\/p><p>SQL is based on the system of relational tables. To simplify, you can think of tables as large spreadsheets. The relationships between two tables are common points between two columns in different tables.<\/p><p>For instance, a <strong>library manager<\/strong> stores information about customers and books in relational tables. Thus, they use a &#8220;Clients&#8221; table that contains each customer&#8217;s ID, first name, last name, address, and the date of their last library subscription.<\/p><p>In this table, two rows can have the same name, first name, or subscription date. However, the ID has been chosen to be unique. This column is called the primary key of &#8220;Clients.&#8221;<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-15838313 elementor-widget elementor-widget-image\" data-id=\"15838313\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"443\" height=\"209\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/image1.jpg\" class=\"attachment-full size-full wp-image-170266\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/image1.jpg 443w, https:\/\/datascientest.com\/en\/files\/2023\/09\/image1-300x142.jpg 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-22d4d10b elementor-widget elementor-widget-text-editor\" data-id=\"22d4d10b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Primary keys<\/strong> are crucial because they allow us to distinguish between rows. For instance, we can use this key to track the actions of different clients without confusing them.<\/p><p>The manager also uses a &#8220;Loans&#8221; table, which contains, for each <strong>current loan,<\/strong> the ID of the loan and the customer, the book title, the author, and the number of days since the loan date.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-197cc876 elementor-widget elementor-widget-image\" data-id=\"197cc876\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"728\" height=\"256\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/image2.png\" class=\"attachment-full size-full wp-image-170267\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/image2.png 728w, https:\/\/datascientest.com\/en\/files\/2023\/09\/image2-300x105.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-34f700c4 elementor-widget elementor-widget-text-editor\" data-id=\"34f700c4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We then realize that <strong>customer IDs<\/strong> are present in both the &#8220;Clients&#8221; table and the &#8220;Loans&#8221; table. As such, we can say that these two tables have a relationship.<\/p><p>Therefore, it is possible for us to execute SQL queries to extract information from one, the other, or both tables simultaneously.<\/p><p>For example, the manager might want to retrieve the first and last names of all customers who borrowed a book more than 3 weeks ago and haven&#8217;t returned it, so they can send them a reminder.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1151e16c e-flex e-con-boxed e-con\" data-id=\"1151e16c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5d7a72f8 elementor-widget elementor-widget-heading\" data-id=\"5d7a72f8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2) SQL Tutorial: The 5 most useful methods<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-30052f74 elementor-widget elementor-widget-text-editor\" data-id=\"30052f74\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Now that you have a general idea of how SQL works, let&#8217;s get to the heart of the matter.<\/p><p>In SQL, lines of code are called <a href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\">queries.<\/a> They consist of methods, which are uppercase words, and attributes, which are usually table or column names written in lowercase<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-61e79bea elementor-widget elementor-widget-heading\" data-id=\"61e79bea\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">A) CREATE TABLE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e9ec4fd elementor-widget elementor-widget-text-editor\" data-id=\"6e9ec4fd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The first method you will need to use is CREATE TABLE. Indeed, as the name suggests, it is the syntax for creating a table.<\/p><p>To perform such an operation, you must first specify the name of the table, as well as the name and type of the columns you want to assign to it<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-44b0131a elementor-widget elementor-widget-heading\" data-id=\"44b0131a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">B) SELECT \u2026 FROM ...<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5524095e elementor-widget elementor-widget-text-editor\" data-id=\"5524095e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>&#8220;This is certainly the most commonly used method. It allows us to select a column from a table.<\/p><p>You need to specify the columns you want to select after &#8220;SELECT&#8221; and which table to search in after &#8220;FROM.&#8221;<\/p><p>For example, to select the list of first names and last names from the &#8220;Clients&#8221; table, the syntax is<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5d9aff04 e-flex e-con-boxed e-con\" data-id=\"5d9aff04\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-6a4bdacd e-con-full e-flex e-con\" data-id=\"6a4bdacd\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1387c2 elementor-widget elementor-widget-text-editor\" data-id=\"1387c2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">SELECT First Name (Pr\u00e9nom), Family Name (Nom) FROM Clients<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6b91ea10 e-con-full e-flex e-con\" data-id=\"6b91ea10\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-31bcb0a7 elementor-widget elementor-widget-image\" data-id=\"31bcb0a7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"189\" height=\"172\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/unnamed-4.png\" class=\"attachment-large size-large wp-image-170268\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-79a0cc1c e-flex e-con-boxed e-con\" data-id=\"79a0cc1c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3a686499 elementor-widget elementor-widget-text-editor\" data-id=\"3a686499\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Note that we often see * after SELECT. This symbol means &#8220;all,&#8221; in other words, if you want to select the entire &#8220;Clients&#8221; table, you would write:<\/p><p>SELECT * FROM Clients<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c63b909 elementor-widget elementor-widget-heading\" data-id=\"c63b909\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">C) WHERE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-467fdb19 elementor-widget elementor-widget-text-editor\" data-id=\"467fdb19\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As we&#8217;ve seen, <strong>SELECT<\/strong> allows you to select all rows in a column. WHERE allows you to specify which rows you want to select or not within that column.<\/p><p>So, you use WHERE after a<strong> SELECT &#8230;<\/strong> FROM &#8230; statement, specifying the condition for selecting one row over another.<\/p><p>For example, to select the subscription date of clients with the name &#8220;Dupond,&#8221; the syntax is:<\/p><p>SELECT Date_Souscription FROM Clients WHERE Nom = Dupond<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36f84af3 elementor-widget elementor-widget-image\" data-id=\"36f84af3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"189\" height=\"172\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/unnamed-4.png\" class=\"attachment-full size-full wp-image-170268\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1665aced elementor-widget elementor-widget-heading\" data-id=\"1665aced\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">D) FULL JOIN \u2026 ON ...<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19013732 elementor-widget elementor-widget-text-editor\" data-id=\"19013732\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Now that we know how to precisely select columns and rows from a table, let&#8217;s see how to retrieve information from two tables simultaneously.<\/p><p>We previously mentioned that the Clients and Emprunts tables have a<strong> relationship because they both contain a column with client IDs.<\/strong><\/p><p>So, it&#8217;s possible to merge these two tables into one, incorporating all the information from the two previous tables.<\/p><p>To do this, you can use the FULL JOIN &#8230; ON &#8230; method. This is used after a SELECT &#8230; FROM &#8230; statement. First, you specify the two tables to join, then the columns that have a relationship.<\/p><p>For example, to select all columns from the merge between Clients and Emprunts, the syntax is:<\/p><p>SELECT *<\/p><p>FROM Clients FULL JOIN Emprunts<\/p><p>ON Clients.Clients_id = Emprunts.Clients_id<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f9ab216 elementor-widget elementor-widget-image\" data-id=\"1f9ab216\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1062\" height=\"299\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/sqll.png\" class=\"attachment-full size-full wp-image-170269\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/sqll.png 1062w, https:\/\/datascientest.com\/en\/files\/2023\/09\/sqll-300x84.png 300w, https:\/\/datascientest.com\/en\/files\/2023\/09\/sqll-1024x288.png 1024w, https:\/\/datascientest.com\/en\/files\/2023\/09\/sqll-768x216.png 768w\" sizes=\"(max-width: 1062px) 100vw, 1062px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2424a075 elementor-widget elementor-widget-text-editor\" data-id=\"2424a075\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We will refer to this new table as Fusion from now on.<\/p><p>Since both tables have <strong>identical column<\/strong> names, it&#8217;s necessary to specify the table name before the column name. For example, Clients.Clients_id represents the Clients_id column of the Clients table.<\/p><p>It&#8217;s also noticeable that some cells contain &#8216;NaN,&#8217; which means missing values. For example, Isabelle Dupond doesn&#8217;t have any current loans.<\/p><p>There are other types of joins (LEFT JOIN, RIGHT JOIN, INNER JOIN) that allow you to keep or discard these types of problematic rows<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a1df8be elementor-widget elementor-widget-heading\" data-id=\"3a1df8be\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">E) GROUP BY<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2cb66f30 elementor-widget elementor-widget-text-editor\" data-id=\"2cb66f30\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We now know how to merge multiple tables, but sometimes it&#8217;s useful to do the opposite and reduce a table to keep only essential information. For example, it might be better to display an average rather than a large number of rows for readability.<\/p><p>GROUP BY is used after a SELECT&#8230; FROM&#8230; statement. We then specify the name of the column on which we want to group the data. However, to perform an operation like an average, a sum&#8230; it&#8217;s necessary to specify it after the SELECT.<\/p><p>For example, to select the number of days since the oldest loan date for each library client, the syntax is:<\/p><p>SELECT Clients_id, MAX(Duration) FROM Fusion GROUP BY Clients_id<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-177ae4aa elementor-widget elementor-widget-image\" data-id=\"177ae4aa\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"222\" height=\"207\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/pasted-image-0.png\" class=\"attachment-full size-full wp-image-170270\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-379b01d8 elementor-widget elementor-widget-text-editor\" data-id=\"379b01d8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">We have completed the<strong> top 5 most useful SQL methods in our <\/strong><\/span>SQL Tutorial.<\/p><p><span style=\"font-weight: 400;\"> You now have the keys to getting started with SQL. If you&#8217;re interested in this language and want to learn more, discover our courses:<br \/><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de81374 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"de81374\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>SQL Tutorial: SQL, or Structured Query Language, is a programming language that is nearly indispensable for managing databases in today&#8217;s data-driven world. In a world where data is a valuable resource in its own right, it&#8217;s easy to understand why knowing how to use this language is a highly sought-after skill. In this article, we [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":170265,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[1417],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Tutorial: Top 5 Most Useful Methods<\/title>\n<meta name=\"description\" content=\"Unlock the power of SQL with our top 5 most useful methods. Master database management and querying. Dive into our SQL tutorial today!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Tutorial: Top 5 Most Useful Methods\" \/>\n<meta property=\"og:description\" content=\"SQL Tutorial: SQL, or Structured Query Language, is a programming language that is nearly indispensable for managing databases in today&#039;s data-driven\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-09T06:17:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T18:52:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/sql-tuto.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"562\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL Tutorial: Top 5 Most Useful Methods\",\"datePublished\":\"2023-09-09T06:17:42+00:00\",\"dateModified\":\"2023-10-30T18:52:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"},\"wordCount\":1088,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Career\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\",\"url\":\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\",\"name\":\"SQL Tutorial: Top 5 Most Useful Methods\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-09-09T06:17:42+00:00\",\"dateModified\":\"2023-10-30T18:52:14+00:00\",\"description\":\"Unlock the power of SQL with our top 5 most useful methods. Master database management and querying. Dive into our SQL tutorial today!\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Tutorial: Top 5 Most Useful Methods","description":"Unlock the power of SQL with our top 5 most useful methods. Master database management and querying. Dive into our SQL tutorial today!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods","og_locale":"en_GB","og_type":"article","og_title":"SQL Tutorial: Top 5 Most Useful Methods","og_description":"SQL Tutorial: SQL, or Structured Query Language, is a programming language that is nearly indispensable for managing databases in today's data-driven","og_url":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-09-09T06:17:42+00:00","article_modified_time":"2023-10-30T18:52:14+00:00","og_image":[{"width":1024,"height":562,"url":"https:\/\/datascientest.com\/en\/files\/2023\/09\/sql-tuto.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL Tutorial: Top 5 Most Useful Methods","datePublished":"2023-09-09T06:17:42+00:00","dateModified":"2023-10-30T18:52:14+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods"},"wordCount":1088,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Career"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods","url":"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods","name":"SQL Tutorial: Top 5 Most Useful Methods","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-09-09T06:17:42+00:00","dateModified":"2023-10-30T18:52:14+00:00","description":"Unlock the power of SQL with our top 5 most useful methods. Master database management and querying. Dive into our SQL tutorial today!","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/170263"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=170263"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/170263\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/170265"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=170263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=170263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=170263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}