KISS series on Analytics: 25 The KEEP clause

Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax.

In this session, we look at the new KEEP clause to collect extra column when performing aggregates, to avoid the need to do another join back to the source table.

========================================­­­­==============
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

[ladduMalik]

I actually wanna appreciate the style of demonstration with little background music.

[TheDarthJester]

In which version of Oracle DB i could start to use KEEP clause?

[cakeman]

I'm having trouble getting this to work. How would the KEEP clause change if you replaced the GROUP BY dept_id with WHERE dept_no = 20 AND sal > 800? IOW, you want the emp_no for the employee in dept_no 20 with a minimum salary > 800.