Home > Tools > Information Designer > Tips and Examples > Examples of Generated SQL > SQL – Filters
In this example we will define a column element with a filter. The column should only return sales transactions above 10000.
Save the column element with the name High Sales.
The column element defined above will result in the following SQL when executed as part of an information link:
SELECT S1."Sales" AS "HIGHSALES" FROM "Sales"."dbo"."SalesandCost" S1 WHERE (S1."Sales" > 10000) AND <conditions> |
See also: