Cart
  • Facebook
  • Twitter
  • Pinterest
  • YouTube
  • RSS

Data Xtractor

  • Products
    • Data Xtractor
    • Divider
    • Visual Xtractor
    • Query Xtractor
    • Model Xtractor
    • Security Xtractor
    • Downloads
  • Buy
    • Subscriptions
    • Divider
    • My Account
    • My Shopping Cart
    • Checkout
  • Support
    • Knowledge Base
    • Chart Types
    • Inline Chart Types
    • Divider
    • FAQ
    • Videos
    • Blog
    • Issues
  • About
    • Consulting Services
    • About Us
    • Contact Us

Query Builder

Query Builder

Window Function Framing: ROWS vs RANGE vs GROUPS

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.

By Cristian Scutaru, 4 yearsAugust 10, 2019 ago
Query Builder

RANGE vs ROWS: When CURRENT ROW is not a Row

Why and when ROWS CURRENT ROW and RANGE CURRENT ROW return different results. How you can visually design this SQL query with window functions and prevent this confusion.

By Cristian Scutaru, 4 yearsAugust 8, 2019 ago
Query Builder

SQL Left Pad (LPAD) Function: Emulated and Built-In

Use one single generic SQL Left Pad string function (LeftPad) for any built-in LPAD function or its emulation with a SQL expression. This article walks through in detail over the generated SQL when LPAD was supported or not. Select LeftPad from our visual SQL query builder, and it will be translated into the appropriate call.

By Cristian Scutaru, 4 yearsJuly 12, 2019 ago
Query Builder

Shared Inline Aggregates with Window Functions for MySQL

Design SQL queries with window functions and reusable OVER clause declarations, regardless of whether or not your database supports the standard SQL WINDOW definition. Design visual SQL queries using MySQL window functions through Data Xtractor. Generate reusable WINDOW definitions, or simply isolate a reusable OVER clause in the visual designer.

By Cristian Scutaru, 4 yearsJuly 8, 2019 ago
Query Builder

Database Products with Window Functions Support

This permanently updated list shows all database products with built-in native support for Window Functions. This includes the OVER clause, named windows or window chaining with the WINDOW clause, together with ranking functions, offset navigational functions and other related functions.

By Cristian Scutaru, 4 yearsJuly 2, 2019 ago

Posts navigation

1 2 3 Next
  • Copyright © 2009-2020 XtractPro Software
  • Terms of Service
  • Privacy Policy
Hestia | Developed by ThemeIsle