Examples of CompareCriteria

org.teiid.query.sql.lang.CompareCriteria
A criteria which represents a simple operator relationship between two expressions. There are 6 operator types. Each side of the comparison may be an expression, which could be an element, a constant, or a function.

Some examples are:
- ticker = 'IBM'
- price >= 50
- revenue < 0
- 5 <= length(companyName)

Examples of org.teiid.query.sql.lang.CompareCriteria

    select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
    
    Criteria having = new CompareCriteria(
      new AggregateSymbol("count", "COUNT", false, new ElementSymbol("b", false)), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      CompareCriteria.GT,
      new Constant(new Integer(0)) );
        
    Query query = new Query();

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.