SQL How-to NVL, NVL2 KEEP DENSE RANK

A video on using the switching functions NVL and NVL2 to handle null values in SQL and how to create a binary flag. Also the use of Keep dense rank to return a value from the first or last row in a rank argument. Part of the SQL How-To Series

A short video on how you can import Excel data into an Oracle database using AllAround Automations PLSQL Developer

Jump to
NVL 5:16 -- Click on the time to jump
NVL2 9:17 -- Click on the time to jump
Keep dense rank 13:02 *You will need to watch the rest of the video for this*