What are the difference between KEEP and OVER keyword in Oracle analytic SQL.
Advertisement
Answer
Keep and OVER clause can be used in same query or individually. While OVER clause is used to work over analytical functions KEEP is used with DENSE_RANK FIRST to KEEP the value of FIRST row in DENSE_RANK.
Please refer to below post for detailed explanation.