http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FTable%2FColumn_Index 2026-05-24T02:55:09Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL/Table/Column_Index&diff=5618&oldid=prev 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://www.sqle.ru/index.php?title=SQL_Server/T-SQL/Table/Column_Index&diff=5619&oldid=prev 2010-05-26T10:19:56Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Reference column index==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 36&gt;<br /> 37&gt; CREATE TABLE works_on (emp_no INTEGER NOT NULL,<br /> 38&gt; project_no CHAR(4) NOT NULL,<br /> 39&gt; job CHAR (15) NULL,<br /> 40&gt; enter_date DATETIME NULL)<br /> 41&gt;<br /> 42&gt; insert into works_on values (1, &quot;p1&quot;, &quot;analyst&quot;, &quot;1997.10.1&quot;)<br /> 43&gt; insert into works_on values (1, &quot;p3&quot;, &quot;manager&quot;, &quot;1999.1.1&quot;)<br /> 44&gt; insert into works_on values (2, &quot;p2&quot;, &quot;clerk&quot;, &quot;1998.2.15&quot;)<br /> 45&gt; insert into works_on values (2, &quot;p2&quot;, NULL, &quot;1998.6.1&quot;)<br /> 46&gt; insert into works_on values (3, &quot;p2&quot;, NULL, &quot;1997.12.15&quot;)<br /> 47&gt; insert into works_on values (4, &quot;p3&quot;, &quot;analyst&quot;, &quot;1998.10.15&quot;)<br /> 48&gt; insert into works_on values (5, &quot;p1&quot;, &quot;manager&quot;, &quot;1998.4.15&quot;)<br /> 49&gt; insert into works_on values (6, &quot;p1&quot;, NULL, &quot;1998.8.1&quot;)<br /> 50&gt; insert into works_on values (7, &quot;p2&quot;, &quot;clerk&quot;, &quot;1999.2.1&quot;)<br /> 51&gt; insert into works_on values (8, &quot;p3&quot;, &quot;clerk&quot;, &quot;1997.11.15&quot;)<br /> 52&gt; insert into works_on values (7, &quot;p1&quot;, &quot;clerk&quot;, &quot;1998.1.4&quot;)<br /> 53&gt;<br /> 54&gt;<br /> 55&gt; SELECT project_no, COUNT(*) emp_quantity<br /> 56&gt; FROM works_on<br /> 57&gt; GROUP BY project_no<br /> 58&gt; ORDER BY 2 DESC<br /> 59&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 /> project_no emp_quantity<br /> ---------- ------------<br /> p1 4<br /> p2 4<br /> p3 3<br /> (3 rows affected)<br /> 1&gt;<br /> 2&gt; drop table works_on<br /> 3&gt; GO<br /> 1&gt;<br /> <br /> &lt;/source&gt;</div>

Admin