SQL examples

This section contains some examples to demonstrate the use of SQL queries in InfoWorks WS Pro.

• SQL example: Critical pipes - This example shows how information from the network combined with data from GIS layers can be used to identify critical pipes.
• SQL example: Validation - This example shows how SQL queries can be used to created complex validation rules.