QAD BI v3 – Tech Level 2 Certification - Part 1 > SQL – Preview > RANK OVER
  PPT
RANK OVER
RANK OVER – continued
 
In this example, to note the effects of ranking duplicate records, using rank over and dense rank over, run the query with the second to last line uncommented, then with it commented out. Also try running the query with the second to last line commented out and the 6th line, perm_transaction_hist.transaction_type commented out. Note how the use of RANK() acts like a group by clause, rolling duplicate data up when transaction type is commented out everywhere.