http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FAnalytical_Functions%2FDENSE_RANK 2026-05-24T11:34:26Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/Analytical_Functions/DENSE_RANK&diff=6398&oldid=prev 2010-05-26T13:46:16Z

<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_Tutorial/Analytical_Functions/DENSE_RANK&diff=6399&oldid=prev 2010-05-26T10:22:55Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== DENSE_RANK() OVER==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 5&gt; create table department(<br /> 6&gt; dept_name char(20) not null,<br /> 7&gt; emp_cnt int not null,<br /> 8&gt; budget float,<br /> 9&gt; date_month datetime);<br /> 10&gt; GO<br /> 1&gt;<br /> 2&gt; insert into department values(&quot;Research&quot;, 5, 50000, &quot;01.01.2002&quot;);<br /> 3&gt; insert into department values(&quot;Research&quot;, 10, 70000, &quot;01.02.2002&quot;);<br /> 4&gt; insert into department values(&quot;Research&quot;, 5, 65000, &quot;01.07.2002&quot;);<br /> 5&gt; insert into department values(&quot;Accounting&quot;, 5, 10000, &quot;01.07.2002&quot;);<br /> 6&gt; insert into department values(&quot;Accounting&quot;, 10, 40000, &quot;01.02.2002&quot;);<br /> 7&gt; insert into department values(&quot;Accounting&quot;, 6, 30000, &quot;01.01.2002&quot;);<br /> 8&gt; insert into department values(&quot;Accounting&quot;, 6, 40000, &quot;01.02.2003&quot;);<br /> 9&gt; insert into department values(&quot;Marketing&quot;, 6, 10000, &quot;01.01.2003&quot;);<br /> 10&gt; insert into department values(&quot;Marketing&quot;, 10, 40000, &quot;01.02.2003&quot;);<br /> 11&gt; insert into department values(&quot;Marketing&quot;, 3, 30000, &quot;01.07.2003&quot;);<br /> 12&gt; insert into department values(&quot;Marketing&quot;, 5, 40000, &quot;01.01.2003&quot;);<br /> 13&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; SELECT DENSE_RANK() OVER(ORDER BY budget DESC) AS rank_budget,<br /> 4&gt; ROW_NUMBER() OVER(ORDER BY budget DESC) AS row_number,dept_name, emp_cnt, budget<br /> 5&gt; FROM department<br /> 6&gt; WHERE budget &lt;= 50000;<br /> 7&gt; GO<br /> rank_budget row_number dept_name emp_cnt budget<br /> -------------------- -------------------- -------------------- ----------- ------------------------<br /> 1 1 Research 5 50000<br /> 2 2 Accounting 10 40000<br /> 2 3 Accounting 6 40000<br /> 2 4 Marketing 10 40000<br /> 2 5 Marketing 5 40000<br /> 3 6 Marketing 3 30000<br /> 3 7 Accounting 6 30000<br /> 4 8 Accounting 5 10000<br /> 4 9 Marketing 6 10000<br /> (9 rows affected)<br /> 1&gt;<br /> 2&gt; drop table department;<br /> 3&gt; GO<br /> 1&gt;<br /> 2&gt;<br /> 3&gt;&lt;/source&gt;</div>

Admin