anchor.diff:  <<<
   [[select_examples]]
   === Examples of SELECT
  +
  +* The following example defines two CTEs, w1 and w2. w2 references w1 which is defined before w2.
  +```
  +>>select * from t1
  +
  + C1 C2
  + ----------
  +
  +  1 1
  +  2 2
  +  3 3
  +  4 4
  +  5 5
  +
  + --- SQL operation complete.
  +
  +>>with w1 as (select * from t1),
  +>>w2 as (select * from w1)
  +>>select * from w2;
  +
  + C1 C2
  + ----------
  +
  +  1 1
  +  2 2
  +  3 3
  +  4 4
  +  5 5
  +
  + --- SQL operation complete.
  +```
  +
  +* The following example defines two CTEs, w1 and w2, and then perform a JOIN between them.
  +```
  +>>select * from t1
  +
  + C1 C2
  + ----------
  +
  +  1 1
  +  2 2
  +  3 3
  +  4 4
  +  5 5
  +
  + --- SQL operation complete.
  +
  +>>select * from t2
  +
  + C1 C2
  + ----------
  +
  +  3 3
  +  4 4
  +  5 5
  +  6 6
  +  7 7
  +
  + --- SQL operation complete.
  +
  +>>with w1 as (select c1, c2 from t1),
  +>>w2 as (select c1, c2 from t2)
  +>>select * from w1, w2 where w1.c1 = w2.c1;
  +
  + C1 C2 C1 C2
  + ----------
  +
  +  3 3 3 3
  +  4 4 4 4
  +  5 5 5 5
  +
  + --- SQL operation complete.
  +```
   
   * Retrieve information from the EMPLOYEE table for employees with a job code greater than 500 and who are in departments
   with numbers less than or equal to 3000, displaying the results in ascending order by job code:
  
positive.code:   | query-expr-and-order
  
  query-specification is:
  SELECT [ "[" ANY N "]" | "[" FIRST N "]" ] [ALL | DISTINCT] select-list
     FROM table-ref [,table-ref]...
     [WHERE search-condition]
  
negative.code: ```
  SELECT sum(distinct a), avg(distinct b), sum(c) from T group by d;
  ```
  
  [[select_considerations_for_with-clause]]
  ==== Considerations for with-clause
  
  * Materialization of CTEs in temporary tables is not yet enabled by default. 
  
  * Trafodion only supports non-recursive common table expressions, which means with-clause cannot be self-referencing, but it can reference a previously defined CTE within the same with-clause.
  
  * The with-clause in Trafodion can be specified only once, at the beginning of a SELECT statement. INSERT, UPDATE, DELETE and CREATE VIEW statements are not supported yet.
  
  [[select_considerations_for_select_list]]
  ==== Considerations for Select List
  