You can translate the document:


The equivalent function for NVL in Denodo Virtual DataPort is called COALESCE. It can be used as follows:

  • select sum(coalesce(field1,0)+coalesce(field2,0)) from view_name;

This function receives a variable number of arguments (two or more), all of the same data type, and returns the first non-null argument.


Advanced VQL Guide: Coalesce


Ask a question

You must sign in to ask a question. If you do not have an account, you can register here