Visual description of the ROWS, RANGE and GROUPS window function clauses. Understand what frame is selected when used on a set with duplicate values. Get the difference between a current row and a current group. Think in terms of either individual rows, or groups with duplicates. Use offset rows, groups or values.
Learn how to perform exploratory analysis in Data Xtractor with a simple example. Discover related tables through expandable relationship items. Display conceptual many-to-many relationships for less diagram clutter. Design complex queries without typing SQL, with a generic visual interface. Generate database-specific SQL. Create inline and regular charts directly from your query results, with trivial chart type selections.