<div>
dense_rank() over (partition by column1_name <b>order by</b> column2_name) <br />
<br />

<blockquote>
<b>DENSE_RANK</b> computes the rank of a row in an ordered group of rows and returns the rank as a NUMBER . The ranks are consecutive integers beginning with 1. The largest rank value is the number of unique values returned by the query. Rank values are not skipped in the event of ties.
</blockquote>
<a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions043.htm" rel="ugc">oracle docs</a><br />
<br />
e.g.<br />
Any person who gets 100% in a test would be ranked 1 (the highest place in class)<br />
Any person who gets 0% in a test would be ranked the lowest in class<br />
<br />
select<br />
&nbsp; &nbsp; &nbsp;person<br />
&nbsp; &nbsp; , dense_rank() over (partition by 1 <b>order by exam_result DESC</b>) &nbsp;as class_rank<br />
from exams<br />
where class = 'year2016 economics'<br />
<br />
------<br />
&quot;group by&quot; is not valid within an OVER() clause
</div>


dense_rank() over (partition by column1_name order by column2_name)



> DENSE_RANK computes the rank of a row in an ordered group of rows and returns the rank as a NUMBER . The ranks are consecutive integers beginning with 1. The largest rank value is the number of unique values returned by the query. Rank values are not skipped in the event of ties.

oracle docs [https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions043.htm]

e.g.
Any person who gets 100% in a test would be ranked 1 (the highest place in class)
Any person who gets 0% in a test would be ranked the lowest in class

select
     person
    , dense_rank() over (partition by 1 order by exam_result DESC)  as class_rank
from exams
where class = 'year2016 economics'

------
"group by" is not valid within an OVER() clause

<div>
Thaks a lot Paul .<br />
I got clear with order by option ,but &nbsp;i have doubt on how to use Group By on partition .
</div>


Thaks a lot Paul .
I got clear with order by option ,but  i have doubt on how to use Group By on partition .

<div>
<div class="content wysiwyg-content">
Hii experts i have a query...<br />
<br />
dense_rank() over (parttition by 1 group by colunm_name) &nbsp; ---what dose this syntax means where exactly it's uses .<br />
<br />
Thanks in Advance
</div>
</div>


Hii experts i have a query...

dense_rank() over (parttition by 1 group by colunm_name)   ---what dose this syntax means where exactly it's uses .

Thanks in Advance

Oracle_Analytics

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.