SQL Examples

This section contains some examples to demonstrate the use of SQL Queries in InfoAsset Manager.

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

• SQL Example - Using Date Functions: shows how to use date functions to calculate the difference in months between the date when a customer complaint was reported and the date when the complaint was finally resolved.