http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FSubquery%2FSubqueries_ALL SQL Server/T-SQL/Subquery/Subqueries ALL - История изменений 2026-04-30T13:56:14Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL/Subquery/Subqueries_ALL&diff=6212&oldid=prev в 13:46, 26 мая 2010 2010-05-26T13:46:06Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://sqle.ru/index.php?title=SQL_Server/T-SQL/Subquery/Subqueries_ALL&diff=6213&oldid=prev Admin: 1 версия 2010-05-26T10:21:36Z <p>1 версия</p> <p><b>Новая страница</b></p><div>==Subqueries and ALL operator==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 11&gt;<br /> 12&gt; CREATE TABLE works_on (emp_no INTEGER NOT NULL,<br /> 13&gt; project_no CHAR(4) NOT NULL,<br /> 14&gt; job CHAR (15) NULL,<br /> 15&gt; enter_date DATETIME NULL)<br /> 16&gt;<br /> 17&gt; insert into works_on values (1, &quot;p1&quot;, &quot;analyst&quot;, &quot;1997.10.1&quot;)<br /> 18&gt; insert into works_on values (1, &quot;p3&quot;, &quot;manager&quot;, &quot;1999.1.1&quot;)<br /> 19&gt; insert into works_on values (2, &quot;p2&quot;, &quot;clerk&quot;, &quot;1998.2.15&quot;)<br /> 20&gt; insert into works_on values (2, &quot;p2&quot;, NULL, &quot;1998.6.1&quot;)<br /> 21&gt; insert into works_on values (3, &quot;p2&quot;, NULL, &quot;1997.12.15&quot;)<br /> 22&gt; insert into works_on values (4, &quot;p3&quot;, &quot;analyst&quot;, &quot;1998.10.15&quot;)<br /> 23&gt; insert into works_on values (5, &quot;p1&quot;, &quot;manager&quot;, &quot;1998.4.15&quot;)<br /> 24&gt; insert into works_on values (6, &quot;p1&quot;, NULL, &quot;1998.8.1&quot;)<br /> 25&gt; insert into works_on values (7, &quot;p2&quot;, &quot;clerk&quot;, &quot;1999.2.1&quot;)<br /> 26&gt; insert into works_on values (8, &quot;p3&quot;, &quot;clerk&quot;, &quot;1997.11.15&quot;)<br /> 27&gt; insert into works_on values (7, &quot;p1&quot;, &quot;clerk&quot;, &quot;1998.1.4&quot;)<br /> 28&gt; GO<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> 1&gt;<br /> 2&gt; -- <br /> 3&gt;<br /> 4&gt; SELECT job FROM works_on WHERE emp_no &lt;= ALL<br /> 5&gt; (SELECT emp_no FROM employee)<br /> 6&gt; GO<br /> job<br /> ---------------<br /> analyst<br /> manager<br /> (2 rows affected)<br /> 1&gt; drop table works_on<br /> 2&gt; GO<br /> 1&gt;<br /> 2&gt;<br /> <br /> &lt;/source&gt;</div> Admin