{"id":969,"date":"2021-07-18T20:30:02","date_gmt":"2021-07-18T20:30:02","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=969"},"modified":"2021-09-09T07:26:21","modified_gmt":"2021-09-09T07:26:21","slug":"what-is-the-difference-between-the-subquery-and-corelated-subquery","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/","title":{"rendered":"What is the difference between the SubQuery and Corelated SubQuery ?"},"content":{"rendered":"<div class=\"TextHeading\">\n<div class=\"hddn\">\n<h2 id=\"subquery\" class=\"color-pink\" style=\"text-align: justify;\"><span style=\"font-family: inherit; font-size: 2rem;\">Subquery<\/span><\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<ul>\n<li>The inner query is executed only once.<\/li>\n<li>The inner query will get executed first and the output of the inner query used by the outer query.<\/li>\n<li>The inner query is not dependent on outer query.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"CodeContent\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<figure class=\"highlight\">\n<pre><code id=\"code1\" class=\"hljs\" data-lang=\"\"><span class=\"nt\">SELECT Employee_name, dept_no \r\nFROM Employee \r\nWHERE Employee_name IN (SELECT Employee_name FROM Customer);<\/span><\/code><\/pre>\n<\/figure>\n<\/div>\n<\/div>\n<div class=\"TextHeading\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<h2 id=\"correlated-subquery\" class=\"color-blue\">Correlated SubQuery<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<ul>\n<li>The outer query will get executed first and for every row of outer query, inner query will get executed.<\/li>\n<li>So the inner query will get executed as many times as number of rows in result of the outer query.<\/li>\n<li>The outer query output can use the inner query output for comparison. This means inner query and outer query dependent on each other.<\/li>\n<\/ul>\n<div class=\"code-embed-wrapper\"> <div class=\"code-embed-infos\"> <\/div> <pre class=\"language-sql code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-sql code-embed-code\">SELECT Employee_name,dept_id <br\/>FROM Employee<br\/>WHERE Employee_name IN (SELECT Employee_name FROM dept WHERE Employee.dept_id=dept.dept_id);<\/code><\/pre> <\/div>\n<\/div>\n<\/div>\n<div class=\"CodeContent\" style=\"text-align: justify;\">\n<div class=\"hddn\"><\/div>\n<\/div>\n<div class=\"ImageContent\">\n<div class=\"hddn\" style=\"text-align: justify;\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png\" alt=\"Subquery and Corelated Subquery\" width=\"411\" height=\"140\" \/><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Answer : The inner query is executed only once&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6547],"tags":[195,6595,203,199,214,198,209,283,6794,6791,6792,6795,6796,6793,6803,6790,6804,6789,205,6800,6798,2936,222,484,196,212,286,970,207,6797,204,6801,6799,282,208,288,206,6802,975,200,197,284,280,364,6788,15901,285],"class_list":["post-969","post","type-post","status-publish","format-standard","hentry","category-sql","tag-accenture-interview-questions-and-answers","tag-allstate-solut-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-chetu-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-conduent-interview-questions-and-answers","tag-correlated-subquery-and-nested-subquery","tag-correlated-subquery-example","tag-correlated-subquery-example-in-oracle","tag-correlated-subquery-example-in-sql-servernon-correlated-subquery","tag-correlated-subquery-in-oracle-10g-example","tag-correlated-subquery-in-sql-server","tag-correlated-subquery-questions","tag-correlated-subquery-tutorial","tag-correlated-subquery-tutorialspoint","tag-correlated-subquery-vs-non-correlated-subquery","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-difference-between-subquery-and-correlated-subquery-in-oracle","tag-example-of-correlated-subquery","tag-fis-global-business-solutions-india-pvt-ltd-interview-questions-and-answers","tag-flipkart-interview-questions-and-answers","tag-genpact-interview-questions-and-answers","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-mindtree-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-non-correlated-subquery-example-in-oracle","tag-oracle-corporation-interview-questions-and-answers","tag-oracle-correlated-subquery-in-from-clause","tag-oracle-correlated-subquery-in-select-clause","tag-persistent-systems-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-r-systems-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-subquery-vs-correlated-subquery","tag-tata-consultancy-service-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-unitedhealth-group-interview-questions-and-answers","tag-valuelabs-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-when-to-use-correlated-subquery","tag-xenosoft-interview-questions-and-answers","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is the difference between the SubQuery and Corelated SubQuery ?<\/title>\n<meta name=\"description\" content=\"What is the difference between the SubQuery and Corelated SubQuery ? - Query is single time validation of conditions for entire result once result is fetched\" \/>\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.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the difference between the SubQuery and Corelated SubQuery ?\" \/>\n<meta property=\"og:description\" content=\"What is the difference between the SubQuery and Corelated SubQuery ? - Query is single time validation of conditions for entire result once result is fetched\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-18T20:30:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-09T07:26:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png\" \/>\n<meta name=\"author\" content=\"Editor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Editor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"What is the difference between the SubQuery and Corelated SubQuery ?\",\"datePublished\":\"2021-07-18T20:30:02+00:00\",\"dateModified\":\"2021-09-09T07:26:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/\"},\"wordCount\":142,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png\",\"keywords\":[\"Accenture interview questions and answers\",\"Allstate Solut interview questions and answers\",\"Capgemini interview questions and answers\",\"CASTING NETWORKS INDIA PVT LIMITED interview questions and answers\",\"CGI Group Inc interview questions and answers\",\"Chetu interview questions and answers\",\"Collabera Technologies interview questions and answers\",\"Conduent interview questions and answers\",\"correlated subquery and nested subquery\",\"correlated subquery example\",\"correlated subquery example in oracle\",\"correlated subquery example in sql servernon correlated subquery\",\"correlated subquery in oracle 10g example\",\"correlated subquery in sql server\",\"correlated subquery questions\",\"correlated subquery tutorial\",\"correlated subquery tutorialspoint\",\"correlated subquery vs non correlated subquery\",\"Dell International Services India Pvt Ltd interview questions and answers\",\"difference between subquery and correlated subquery in oracle\",\"example of correlated subquery\",\"FIS Global Business Solutions India Pvt Ltd interview questions and answers\",\"Flipkart interview questions and answers\",\"Genpact interview questions and answers\",\"IBM interview questions and answers\",\"Indecomm Global Services interview questions and answers\",\"L&amp;T Infotech interview questions and answers\",\"Mindtree interview questions and answers\",\"Mphasis interview questions and answers\",\"non correlated subquery example in oracle\",\"Oracle Corporation interview questions and answers\",\"oracle correlated subquery in from clause\",\"oracle correlated subquery in select clause\",\"Persistent Systems interview questions and answers\",\"Prokarma Softech Pvt Ltd interview questions and answers\",\"R Systems interview questions and answers\",\"SAP Labs India Pvt Ltd interview questions and answers\",\"subquery vs correlated subquery\",\"Tata Consultancy Service interview questions and answers\",\"Tech Mahindra interview questions and answers\",\"UnitedHealth Group interview questions and answers\",\"ValueLabs interview questions and answers\",\"Virtusa Consulting Services Pvt Ltd interview questions and answers\",\"Wells Fargo interview questions and answers\",\"when to use correlated subquery\",\"xenosoft interview questions and answers\",\"Xoriant Solutions Pvt Ltd interview questions and answers\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/\",\"name\":\"What is the difference between the SubQuery and Corelated SubQuery ?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png\",\"datePublished\":\"2021-07-18T20:30:02+00:00\",\"dateModified\":\"2021-09-09T07:26:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"What is the difference between the SubQuery and Corelated SubQuery ? - Query is single time validation of conditions for entire result once result is fetched\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png\",\"contentUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\",\"name\":\"Editor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"caption\":\"Editor\"},\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/editor\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is the difference between the SubQuery and Corelated SubQuery ?","description":"What is the difference between the SubQuery and Corelated SubQuery ? - Query is single time validation of conditions for entire result once result is fetched","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.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/","og_locale":"en_US","og_type":"article","og_title":"What is the difference between the SubQuery and Corelated SubQuery ?","og_description":"What is the difference between the SubQuery and Corelated SubQuery ? - Query is single time validation of conditions for entire result once result is fetched","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/","og_site_name":"Wikitechy","article_published_time":"2021-07-18T20:30:02+00:00","article_modified_time":"2021-09-09T07:26:21+00:00","og_image":[{"url":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png","type":"","width":"","height":""}],"author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"What is the difference between the SubQuery and Corelated SubQuery ?","datePublished":"2021-07-18T20:30:02+00:00","dateModified":"2021-09-09T07:26:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/"},"wordCount":142,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png","keywords":["Accenture interview questions and answers","Allstate Solut interview questions and answers","Capgemini interview questions and answers","CASTING NETWORKS INDIA PVT LIMITED interview questions and answers","CGI Group Inc interview questions and answers","Chetu interview questions and answers","Collabera Technologies interview questions and answers","Conduent interview questions and answers","correlated subquery and nested subquery","correlated subquery example","correlated subquery example in oracle","correlated subquery example in sql servernon correlated subquery","correlated subquery in oracle 10g example","correlated subquery in sql server","correlated subquery questions","correlated subquery tutorial","correlated subquery tutorialspoint","correlated subquery vs non correlated subquery","Dell International Services India Pvt Ltd interview questions and answers","difference between subquery and correlated subquery in oracle","example of correlated subquery","FIS Global Business Solutions India Pvt Ltd interview questions and answers","Flipkart interview questions and answers","Genpact interview questions and answers","IBM interview questions and answers","Indecomm Global Services interview questions and answers","L&amp;T Infotech interview questions and answers","Mindtree interview questions and answers","Mphasis interview questions and answers","non correlated subquery example in oracle","Oracle Corporation interview questions and answers","oracle correlated subquery in from clause","oracle correlated subquery in select clause","Persistent Systems interview questions and answers","Prokarma Softech Pvt Ltd interview questions and answers","R Systems interview questions and answers","SAP Labs India Pvt Ltd interview questions and answers","subquery vs correlated subquery","Tata Consultancy Service interview questions and answers","Tech Mahindra interview questions and answers","UnitedHealth Group interview questions and answers","ValueLabs interview questions and answers","Virtusa Consulting Services Pvt Ltd interview questions and answers","Wells Fargo interview questions and answers","when to use correlated subquery","xenosoft interview questions and answers","Xoriant Solutions Pvt Ltd interview questions and answers"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/","name":"What is the difference between the SubQuery and Corelated SubQuery ?","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png","datePublished":"2021-07-18T20:30:02+00:00","dateModified":"2021-09-09T07:26:21+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"What is the difference between the SubQuery and Corelated SubQuery ? - Query is single time validation of conditions for entire result once result is fetched","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery\/#primaryimage","url":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png","contentUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/what-is-the-difference-between-the-subquery-and-corelated-subquery.png"},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757","name":"Editor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","caption":"Editor"},"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/editor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=969"}],"version-history":[{"count":3,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/969\/revisions"}],"predecessor-version":[{"id":3161,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/969\/revisions\/3161"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}