{"id":586,"date":"2022-07-29T10:48:55","date_gmt":"2022-07-29T10:48:55","guid":{"rendered":"http:\/\/www.softwaretraininginchennai.com\/blog\/?p=586"},"modified":"2022-07-29T10:48:55","modified_gmt":"2022-07-29T10:48:55","slug":"subquery-in-sql","status":"publish","type":"post","link":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/","title":{"rendered":"Subquery in SQL"},"content":{"rendered":"

Query<\/u>:<\/strong> A query is\u00a0a request for data or information from one or more tables of a database.<\/p>\n

Sub Query<\/u>:<\/strong> In SQL language, we can place a Query inside another Query. This Query which is placed inside another query is called as subquery, also known as Nested Query<\/p>\n

Subqueries can be used with SELECT, UPDATE, INSERT, DELETE statements along with the equality operator or comparison operator such as =, >, =, <= and Like operator.<\/p>\n

Subquery must be enclosed in parentheses.<\/p>\n

An ORDER BY command cannot be used in a subquery, but the main query can use an ORDER BY. The GROUP BY command can be used instead of ORDER BY in a subquery.<\/p>\n

 <\/p>\n

Subquery – SELECT Statement<\/strong><\/p>\n

Consider a Query<\/p>\n

Select * from StudentDetails <\/em><\/p>\n

When this query when executed, selects all rows of the table<\/p>\n

Now consider an example with subquery Select<\/p>\n

Select * from StudentDetails <\/em><\/p>\n

where ID in (Select ID from StudentDetails where Percentage > 90);<\/em><\/p>\n

When this set of queries gets executed,<\/p>\n

Always the subquery gets executed first, selects the ID from StudentDetails table whose percentage is greater than 90, And then the outer query gets executed later, selecting the ID equal to the result of subquey<\/p>\n

 <\/p>\n

Subquery – INSERT Statement<\/strong><\/p>\n

Now consider an example with subquery Insert<\/p>\n

Insert into StudentDetails_new<\/p>\n

Select * from StudentDetails where ID in (Select ID from StudentDetails );<\/em><\/p>\n

Here a new table with StudentDetails_new is created with the same structure as StudentDetails table, now to copy the datas of StudentDetails table to StudentDetails_new table , insert\u00a0 statement can be used.<\/p>\n

 <\/p>\n

Subquery – UPDATE Statement<\/strong><\/p>\n

Now consider an example with subquery update<\/p>\n

update StudentDetails<\/p>\n

Set mark = mark + 5<\/em><\/p>\n

Where mark in (Select mark from StudentDetails where mark >= 91);<\/em><\/p>\n

Here in the table StudentDetails, the mark can be updated with a bonus of 5 marks for those who have scored mark of 91 and above using this update statement.<\/p>\n

 <\/p>\n

Subquery – DELETE Statement<\/strong><\/p>\n

Now consider an example with subquery delete<\/p>\n

Delete from <\/em>StudentDetails<\/em><\/p>\n

Where mark in (Select mark from StudentDetails where mark < 50);<\/em><\/p>\n

Here in the table StudentDetails, the datas with marks less than 50 can be removed using delete statement.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Query: A query is\u00a0a request for data or information from one or more tables of a database. Sub Query: In SQL language, we can place a Query inside another Query. This Query which is placed inside another query is called as subquery, also known as Nested Query Subqueries can be used with SELECT, UPDATE, INSERT, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,220,234],"tags":[14,239,238],"class_list":["post-586","post","type-post","status-publish","format-standard","hentry","category-dot-net-training-in-chennai","category-free-dotnet-training","category-sql-server","tag-net-training-in-chennai","tag-asp-net-training-in-madurai","tag-sql-net-training-in-karaikudi"],"yoast_head":"\nSubquery in SQL | Maria Academy<\/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.softwaretraininginchennai.com\/blog\/subquery-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Subquery in SQL | Maria Academy\" \/>\n<meta property=\"og:description\" content=\"Query: A query is\u00a0a request for data or information from one or more tables of a database. Sub Query: In SQL language, we can place a Query inside another Query. This Query which is placed inside another query is called as subquery, also known as Nested Query Subqueries can be used with SELECT, UPDATE, INSERT, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Maria Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DotnetTrainingChennai\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-29T10:48:55+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:site\" content=\"@dotnettraining2\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"headline\":\"Subquery in SQL\",\"datePublished\":\"2022-07-29T10:48:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/\"},\"wordCount\":355,\"commentCount\":0,\"keywords\":[\".net training in Chennai\",\"asp.net training in madurai\",\"SQL \/ .net training in karaikudi\"],\"articleSection\":[\"dot net training in chennai\",\"Free dotnet training\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/\",\"name\":\"Subquery in SQL | Maria Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\"},\"datePublished\":\"2022-07-29T10:48:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Subquery in SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\",\"name\":\"Maria Academy\",\"description\":\"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Subquery in SQL | Maria Academy","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.softwaretraininginchennai.com\/blog\/subquery-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"Subquery in SQL | Maria Academy","og_description":"Query: A query is\u00a0a request for data or information from one or more tables of a database. Sub Query: In SQL language, we can place a Query inside another Query. This Query which is placed inside another query is called as subquery, also known as Nested Query Subqueries can be used with SELECT, UPDATE, INSERT, […]","og_url":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/","og_site_name":"Maria Academy","article_publisher":"https:\/\/www.facebook.com\/DotnetTrainingChennai","article_published_time":"2022-07-29T10:48:55+00:00","author":"admin","twitter_card":"summary_large_image","twitter_creator":"@dotnettraining2","twitter_site":"@dotnettraining2","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#article","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/"},"author":{"name":"admin","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"headline":"Subquery in SQL","datePublished":"2022-07-29T10:48:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/"},"wordCount":355,"commentCount":0,"keywords":[".net training in Chennai","asp.net training in madurai","SQL \/ .net training in karaikudi"],"articleSection":["dot net training in chennai","Free dotnet training","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/","name":"Subquery in SQL | Maria Academy","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website"},"datePublished":"2022-07-29T10:48:55+00:00","author":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"breadcrumb":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/subquery-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretraininginchennai.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Subquery in SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/","name":"Maria Academy","description":"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/comments?post=586"}],"version-history":[{"count":1,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/586\/revisions"}],"predecessor-version":[{"id":587,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/586\/revisions\/587"}],"wp:attachment":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/media?parent=586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/categories?post=586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/tags?post=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}