rank() assigns each row a unique number (rank) giving identical ranking for duplicate values,leaving a gap in the sequence to the next rank. dense rank() similar to rank(), it leaves no gaps in the rank after identical ranking. this link http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php
ERP Project Management,Asp.net,PL SQL Tips for error resolution,Research,Software Errors and solution,SQL 2014,2012,2008,Procedural language,SP,Power BI,excel macro ,Musical notations,Business software,Degree, diploma related informations.