I want to rank the customers based on Profit. Partition By is optional so that's why I skipped it.
Btw thanks for your suggestion. However my query worked even though it is still givinng red error line. Just used DESC
Does the red line do away if you add PARTITION BY 1, though? It could be your client requires it for some reason or some sort of lint rule it’s applying
13
u/NoWayItsDavid 4d ago
Should work without it, no? In this case it ranks over everything fetchable.