{"id":2426,"date":"2022-10-29T11:15:25","date_gmt":"2022-10-29T06:15:25","guid":{"rendered":"https:\/\/www.yourrightdecision.com\/blog\/?p=2426"},"modified":"2022-11-04T16:02:16","modified_gmt":"2022-11-04T11:02:16","slug":"sql-structured-query-language","status":"publish","type":"post","link":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/","title":{"rendered":"Learn SQL (Structured Query Language) by Examples"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"520\" height=\"513\" src=\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg\" alt=\"\" class=\"wp-image-2481\" srcset=\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg 520w, https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215-300x296.jpg 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/figure>\n\n\n\n<p>SQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in databases. SQL statements are used to perform tasks such as updating data on a database or retrieving data from a database.<\/p>\n\n\n\n<p>There are five types of SQL commands: DDL, DML, DCL, TCL, and DQL.<\/p>\n\n\n\n<p><strong>Data Definition Language (DDL)<\/strong> defines the structure of the database like creating a table, deleting a table, or altering a table.<\/p>\n\n\n\n<p><strong>Data Manipulation Language (DML)<\/strong> commands are used to modify the database such as Insert, Update, and Delete. <\/p>\n\n\n\n<p><strong>Data Control Language (DCL)<\/strong> commands are used to grant and take back authority from any database user such as Grant and Revoke.<\/p>\n\n\n\n<p><strong>Transaction Control Language (TCL)<\/strong> commands can only be used with DML commands like Insert, Delete and Update. These commands include Commit, Rollback, and Savepoint.<\/p>\n\n\n\n<p><strong>Data Query Language (DQL)<\/strong> is used to fetch the data from the database. It uses only one command: Select.<\/p>\n\n\n\n<p>In this blog post, I am sharing some basic and advanced SQL statements so that they could serve as a handy reference for you while accessing a database. SQL Syntax vary slightly based on the database used such as SQL Server, Oracle, or Microsoft Access. In this post, I have mostly used SQL Server Database.<\/p>\n\n\n\n<p>Show all the columns from a table (square brackets and database name are optional):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM &#91;HumanResources].&#91;Employee]<\/code><\/pre>\n\n\n\n<p>Show the loginid and gender column:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT &#91;LoginID],&#91;Gender]\nFROM &#91;HumanResources].&#91;Employee]<\/code><\/pre>\n\n\n\n<p>Use alias for the column name:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Gender g\nFROM &#91;HumanResources].&#91;Employee]<\/code><\/pre>\n\n\n\n<p>Use alias for the table name:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT e.Gender\nFROM &#91;HumanResources].&#91;Employee] e<\/code><\/pre>\n\n\n\n<p>Select distinct values:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT DISTINCT Employee.Gender\nFROM &#91;HumanResources].&#91;Employee]<\/code><\/pre>\n\n\n\n<p>Show the first 10 rows of the table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT TOP 10 e.&#91;BusinessEntityID], e.Gender g\nFROM &#91;HumanResources].&#91;Employee] e<\/code><\/pre>\n\n\n\n<p>Sorting the results:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT &#91;BusinessEntityID]\nFROM &#91;HumanResources].&#91;Employee]\nORDER BY &#91;BusinessEntityID] desc<\/code><\/pre>\n\n\n\n<p>Filter the data by using WHERE clause:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select &#91;BusinessEntityID], &#91;JobTitle]\nfrom &#91;HumanResources].&#91;Employee]\nwhere JobTitle='Design Engineer'<\/code><\/pre>\n\n\n\n<p>Search for a pattern by using LIKE:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT &#91;BusinessEntityID], &#91;JobTitle]\nFROM &#91;HumanResources].&#91;Employee]\nWHERE JobTitle LIKE 'Design%'<\/code><\/pre>\n\n\n\n<p>Filter for specific values by using IN operator:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT &#91;BusinessEntityID],JobTitle\nFROM &#91;HumanResources].&#91;Employee]\nWHERE JobTitle in ('Engineering Manager','Senior Tool Designer')<\/code><\/pre>\n\n\n\n<p>Aggregate the data by using SUM and AVG functions:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SUM(&#91;SubTotal]) AS SUBTOTAL,AVG(&#91;SubTotal]) AS AVERAGESUBTOTAL\nFROM &#91;Sales].&#91;SalesOrderHeader]<\/code><\/pre>\n\n\n\n<p>Get the sum of the orderQty column, group the information by salesorderid, and ordering the sum in descending order. Note that the GROUP BY clause will be executed first to group the data by salesorderid. Then the sum function will add the quantities ordered for that salesorderid:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SUM(&#91;OrderQty]) AS Qty, &#91;SalesOrderID]\nFROM &#91;Sales].&#91;SalesOrderDetail]\nGROUP BY &#91;SalesOrderID]\nORDER BY SUM(&#91;OrderQty]) DESC<\/code><\/pre>\n\n\n\n<p>Having Clause for Aggregate Functions<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT COUNT(CustomerID), Country\nFROM Customers\nGROUP BY Country\nHAVING COUNT(CustomerID) > 5\nORDER BY COUNT(CustomerID) DESC<\/code><\/pre>\n\n\n\n<p>Inner Join:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT customerName, customercity, customermail, salestotal\nFROM onlinecustomers INNER JOIN orders\n   ON onlinecustomers.customerid = orders.customerid\n   INNER JOIN sales \n   ON orders.orderId = sales.orderId<\/code><\/pre>\n\n\n\n<p>Left Join (Will display all customers and their orders if any):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Customers.CustomerName, Orders.OrderID\nFROM Customers\nLEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID\nORDER BY Customers.CustomerName<\/code><\/pre>\n\n\n\n<p>Right Join (Will display all employees and their orders if any):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Orders.OrderID, Employees.LastName, Employees.FirstName\nFROM Orders\nRIGHT JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID\nORDER BY Orders.OrderID<\/code><\/pre>\n\n\n\n<p>Full Join (Will display all customers and all orders)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Customers.CustomerName, Orders.OrderID\nFROM Customers\nFULL OUTER JOIN Orders ON Customers.CustomerID=Orders.CustomerID\nORDER BY Customers.CustomerName<\/code><\/pre>\n\n\n\n<p>Self Join (matches customers that are from the same city)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT A.CustomerName AS CustomerName1, B.CustomerName AS CustomerName2, A.City\nFROM Customers A, Customers B\nWHERE A.CustomerID &lt;> B.CustomerID\nAND A.City = B.City\nORDER BY A.City<\/code><\/pre>\n\n\n\n<p>Exists (List the suppliers with a product price equal to 22)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SupplierName\nFROM Suppliers\nWHERE EXISTS (SELECT ProductName FROM Products WHERE Products.SupplierID = Suppliers.supplierID AND Price = 22)<\/code><\/pre>\n\n\n\n<p>Here SP1 is first SAVEPOINT created before deletion. Deletion is then undone:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SAVEPOINT SP1;\nDELETE FROM Student WHERE AGE = 20;\nSAVEPOINT SP2;\nROLLBACK TO SP1;<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Useful Resources:<\/h1>\n\n\n\n<p>SQL Commands: DDL, DML, DCL, TCL, DQL<br><a href=\"https:\/\/www.javatpoint.com\/dbms-sql-command\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.javatpoint.com\/dbms-sql-command<\/a><\/p>\n\n\n\n<p>SQL Queries in SQL Server \u2013 a beginner\u2019s guide<br><a href=\"https:\/\/www.sqlshack.com\/sql-queries-in-sql-server-a-beginners-guide\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.sqlshack.com\/sql-queries-in-sql-server-a-beginners-guide<\/a><\/p>\n\n\n\n<p>SQL multiple joins for beginners with examples<br><a href=\"https:\/\/www.sqlshack.com\/sql-multiple-joins-for-beginners-with-examples\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.sqlshack.com\/sql-multiple-joins-for-beginners-with-examples<\/a><\/p>\n\n\n\n<p>SQL Joins<br><a rel=\"noreferrer noopener\" href=\"https:\/\/www.w3schools.com\/sql\/sql_join.asp\" target=\"_blank\">https:\/\/www.w3schools.com\/sql\/sql_join.asp<\/a><\/p>\n\n\n\n<p>SQL Transactions<br><a rel=\"noreferrer noopener\" href=\"https:\/\/www.geeksforgeeks.org\/sql-transactions\" target=\"_blank\">https:\/\/www.geeksforgeeks.org\/sql-transactions<\/a><\/p>\n\n\n\n<p>SQL Server Interview Questions and Answers by kudvenkat<br><a href=\"https:\/\/www.youtube.com\/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.youtube.com\/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in databases. SQL&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,9],"tags":[40,39,38,41],"class_list":["post-2426","post","type-post","status-publish","format-standard","hentry","category-programming","category-tech","tag-programming","tag-query","tag-sql","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learn SQL (Structured Query Language) by Examples - Your Right Decision Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn SQL (Structured Query Language) by Examples - Your Right Decision Blog\" \/>\n<meta property=\"og:description\" content=\"SQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in databases. SQL&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/\" \/>\n<meta property=\"og:site_name\" content=\"Your Right Decision Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/yourrightdecision\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-29T06:15:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-04T11:02:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641\"},\"headline\":\"Learn SQL (Structured Query Language) by Examples\",\"datePublished\":\"2022-10-29T06:15:25+00:00\",\"dateModified\":\"2022-11-04T11:02:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/\"},\"wordCount\":489,\"commentCount\":31,\"publisher\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg\",\"keywords\":[\"programming\",\"query\",\"sql\",\"sqlserver\"],\"articleSection\":[\"Programming\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/\",\"name\":\"Learn SQL (Structured Query Language) by Examples - Your Right Decision Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg\",\"datePublished\":\"2022-10-29T06:15:25+00:00\",\"dateModified\":\"2022-11-04T11:02:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg\",\"contentUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg\",\"width\":520,\"height\":513},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.yourrightdecision.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn SQL (Structured Query Language) by Examples\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#website\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/\",\"name\":\"Your Right Decision Blog\",\"description\":\"Your Right Decision on the Web\",\"publisher\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.yourrightdecision.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#organization\",\"name\":\"Your Right Decision\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg\",\"contentUrl\":\"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg\",\"width\":364,\"height\":364,\"caption\":\"Your Right Decision\"},\"image\":{\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/yourrightdecision\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn SQL (Structured Query Language) by Examples - Your Right Decision Blog","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:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/","og_locale":"en_US","og_type":"article","og_title":"Learn SQL (Structured Query Language) by Examples - Your Right Decision Blog","og_description":"SQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in databases. SQL&hellip;","og_url":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/","og_site_name":"Your Right Decision Blog","article_publisher":"https:\/\/www.facebook.com\/yourrightdecision","article_published_time":"2022-10-29T06:15:25+00:00","article_modified_time":"2022-11-04T11:02:16+00:00","og_image":[{"url":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#article","isPartOf":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/"},"author":{"name":"admin","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641"},"headline":"Learn SQL (Structured Query Language) by Examples","datePublished":"2022-10-29T06:15:25+00:00","dateModified":"2022-11-04T11:02:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/"},"wordCount":489,"commentCount":31,"publisher":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg","keywords":["programming","query","sql","sqlserver"],"articleSection":["Programming","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/","url":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/","name":"Learn SQL (Structured Query Language) by Examples - Your Right Decision Blog","isPartOf":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage"},"image":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg","datePublished":"2022-10-29T06:15:25+00:00","dateModified":"2022-11-04T11:02:16+00:00","breadcrumb":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#primaryimage","url":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg","contentUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2022\/10\/215.jpg","width":520,"height":513},{"@type":"BreadcrumbList","@id":"https:\/\/www.yourrightdecision.com\/blog\/sql-structured-query-language\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yourrightdecision.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Learn SQL (Structured Query Language) by Examples"}]},{"@type":"WebSite","@id":"https:\/\/www.yourrightdecision.com\/blog\/#website","url":"https:\/\/www.yourrightdecision.com\/blog\/","name":"Your Right Decision Blog","description":"Your Right Decision on the Web","publisher":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yourrightdecision.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.yourrightdecision.com\/blog\/#organization","name":"Your Right Decision","url":"https:\/\/www.yourrightdecision.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg","contentUrl":"https:\/\/www.yourrightdecision.com\/blog\/wp-content\/uploads\/2020\/11\/156.jpg","width":364,"height":364,"caption":"Your Right Decision"},"image":{"@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/yourrightdecision"]},{"@type":"Person","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/1619bc20b251247bf3089fa41c507641","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yourrightdecision.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ae389a5bfe7418706d8fd3157e4bd2b?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts\/2426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/comments?post=2426"}],"version-history":[{"count":17,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts\/2426\/revisions"}],"predecessor-version":[{"id":2527,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/posts\/2426\/revisions\/2527"}],"wp:attachment":[{"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/media?parent=2426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/categories?post=2426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yourrightdecision.com\/blog\/wp-json\/wp\/v2\/tags?post=2426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}