Aspects
Max
Maximum value
Rank
Rank refers to the relative position, value, worth, complexity, power, level etc
Time larger new
| Quality | Example |
|---|---|
| Lower |
"If no rank is lower than its number there are no gaps in the table the query returns the max number + 1" from question "Returning the lowest integer not in a list in SQL" |
| Larger number |
"Every time a rank finds a larger number than that stored have it send its new max to the root rank" from question "Synchronazing data between all MPI tasks" |
Others
| Quality | Example |
|---|---|
| Usually slower |
"You might replace the max subquery with a rank max is usually slower only when cus_id is the pi rank might be worse" from question "Large Table vs Multiple Tables - Normalized Data" |
| Faster |
"While i think gbn s answer is probably sufficient i m wondering whether use of an over clause to establish a max date per id attribute with which to reduce the select in a where clause wouldn t be faster than a rank" from question "What is the fastest way to query from a historical EAV database" |
| Greater |
"So i want to generate rank for second set of values but starting with value greater than max from first set" from question "Pig Latin - adding values from different bags?" |
| Less |
"If your rank is less than 4 it takes 0 instead it s the max part" from question "User centered top list" |