SQL Tutorial : Difference Between NVL and NVL2 functions in sql

[@dastageerpinjar5065]

Im glad and happy that Today i found ur channel....i go through all content u prepared....which is my need of the hour....thanks a lot

[@dastageerpinjar5065]

Best easy explanation....

[@TRRaveendra]

Thank you 👍

[@jayanthi3112]

Good explanation...thank you

[@manjushreesb7580]

Managements wants to know the manager of each resort.
Display resortid , resort name, manager name and his phone. Sort the output in ascending order of resort id. Give alias to manager name as MANAGERNAME and phone as PHONENO.
If manager is not available then display manager name 'NA'. If phone number is not available then display as 'NA'.
Sir can I get an ans for this

[@michaelcastillo5809]

Consider using these different functions. Hope it helps
*ISNULL ( )* for SQL Server
*IsNull ( ) * for MS Access
*COALESCE ( )* or *IFNULL ( )* for MySQL
*NVL ( )* for Oracle

[@manjushreesb7580]

@@michaelcastillo5809 thank you soo much ❤️

[@shobhikpaul1607]

horrible man