Results of 1 - 3 of about 3 for interest (0.001 sec.)
- Subqueries 11849
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...ally the most useful as a correlated subquery to express antijoin operations. For example, to find Person nodes without an interest: CREATE TABLE Person (id BIGINT, name VARCHAR); CREATE TABLE interest (PersonId BIGINT, topic VARCHAR); INSERT INTO Person...VALUES (1, 'Jane'), (2, 'Joe'); INSERT INTO interest VALUES (2, 'Music'); SELECT * FROM Person WHERE NOT EXISTS (FROM interest WHERE interest.PersonId = Person.id); id name 1... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- R-Tree Indexes 8538
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...ial relationship with a specific region of interest. Unfortunately, even though DuckDB's vectorized execution engine is pretty fast, this sort of operation does not scale ver...quickly search a R-tree-indexed table for only those rows where the indexed geometry column intersect a specific region of interest, as you can skip searching entire sub-trees if the bounding rectangles of their parent nodes don't intersect the query reg... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- WITH Clause 7478
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...de In most cases, enumerating all paths is not practical or feasible. Instead, only the (unweighted) shortest paths are of interest. To find these, the second half of the WITH RECURSIVE query should be adjusted such that it only includes a node if it has... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work