From: Tonkuma on 29 May 2010 11:07 XMLGROUP implies grouping, and you didn't specified GROUP BY clause nand WHERE clause. So, all rows in the table will be grouped in one group. Then, the query fetches first two rows (actually only one row will be returned.) Also refer to the manual "DB2 for Linux, UNIX, and Windows SQL Reference Volume 1" ---> Chapter 5. SQL queries ---> Subselect The clauses of the subselect are processed in the following sequence: 1. FROM clause 2. WHERE clause 3. GROUP BY clause 4. HAVING clause 5. SELECT clause 6. ORDER BY clause 7. FETCH FIRST clause
|
Pages: 1 Prev: FYI: DB2 9.7.2 eGA with more SQL goodies to get off Oracle Next: PLAY RACE GAMES |