skip to main content
Non-Supported SQL-92 functionality : Value expressions : Advanced value expressions : Row value constructor
 

Row value constructor

A row value constructor is a parenthesized list of values.

Example 

The following expression:
WHERE c1=CA AND c2=CB AND c3=CC
can be written using row value constructor as:
WHERE (c1, c2, c3) = (CA, CB, CC)