|
![]() |
![]() |
![]() |
The LIKE condition allows you to use wildcards in the WHERE clause
of an SQL statement. This allows pattern matching.
The patterns
that you can choose from are:
The arithmetical standard operators for addition (+), subtraction (-), multiplication (*) and division (/) can all be used for numerical constant or for attributes with a numerical domain.
In the above example the result is a relation with three attributes. The third attribute is named "Usury" since "Price/Size" is not a good name and stands for the price per unit. We define that if it lies over 15, it is overpriced ("Usury").
![]() |
![]() |
![]() |
![]() |