Skip to content
Advertisement

What are difference between KEEP and OVER in Oracle analytic SQL [closed]

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.

POST

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement