1.0Database Tutorialshttps://dbtut.comdbtuthttps://dbtut.com/index.php/author/dbtut/SubQueries in SQL Server(TSQL) - Database Tutorialsrich600338<blockquote class="wp-embedded-content" data-secret="LycKPqScKl"><a href="https://dbtut.com/index.php/2019/01/08/subqueries-in-sql-servertsql/">SubQueries in SQL Server(TSQL)</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://dbtut.com/index.php/2019/01/08/subqueries-in-sql-servertsql/embed/#?secret=LycKPqScKl" width="600" height="338" title="“SubQueries in SQL Server(TSQL)” — Database Tutorials" data-secret="LycKPqScKl" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://dbtut.com/wp-includes/js/wp-embed.min.js
/* ]]> */
</script>
In SQL Server, you can write query in a query. You can write the subqueries in the SELECT section, FROM section, and the WHERE section of the query. The Main query is also known as OUTER QUERY or OUTER SELECT, and subquery is known as INNER QUERY or INNER SELECT In the following example, …https://dbtut.com/wp-content/uploads/2019/01/695.png