Results of 1 - 9 of about 9 for attributes (0.005 sec.)
- FROM and JOIN Clauses 13589
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...st once) A join that is not OUTER is INNER (only rows that get paired are returned). When an unpaired row is returned, the attributes from the other table are set to NULL . Cross Product Joins (Cartesian Product) The simplest type of join is a CROSS JOIN ....itting the JOIN clause: SELECT a.*, b.* FROM a, b; Conditional Joins Most joins are specified by a predicate that connects attributes from one side to attributes from the other side. The conditions can be explicitly specified using an ON clause with the jo...FROM west s1, west s2 WHERE s1.time > s2.time AND s1.cost < s2.cost; Natural Joins Natural joins join two tables based on attributes that share the same name. For example, take the following example with cities, airport codes and airport names. Note that... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- ODBC Extension Functions 9958
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...USER or SYSTEM Example: FROM odbc_list_data_sources() odbc_list_drivers odbc_list_drivers() -> TABLE(description VARCHAR, attributes MAP(VARCHAR, VARCHAR)) Returns the list of ODBC drivers registered in the OS. Uses driver manager call SQLDrivers . Parame...ters: None. Returns: A table with the following columns: description ( VARCHAR ): driver description attributes ( MAP(VARCHAR, VARCHAR) ): driver attributes as a name->value map Example: FROM odbc_list_drivers() odbc_query odbc_query(... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Run Queries 9418
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
....user.DuckDBUserArray (a java.sql.Array ) for a LIST or ARRAY , where typeName is the element type. createStruct(typeName, attributes) — the standard JDBC method — returns an org.duckdb.user.DuckDBUserStruct (a java.sql.Struct ), where typeName is the STRU...CT type and attributes are the field values in declaration order. createMap(typeName, map) — a DuckDB extension on DuckDBConnection — returns an... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Friendly SQL 8304
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...all columns (performing a SELECT * statement). GROUP BY ALL : omit the group-by columns by inferring them from the list of attributes in the SELECT clause. ORDER BY ALL : shorthand to order on all columns (e.g., to ensure deterministic results). SELECT * E... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- PostgreSQL Compatibility 8304
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...to the GROUP BY list, or use "ANY_VALUE(j)" if the exact value of "j" is not important. To work around this, add the other attributes or use the GROUP BY ALL clause . Behavior of Regular Expression Match Operators PostgreSQL supports the POSIX regular expr... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- DuckDB_% Metadata Functions 8304
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
....) , or NULL if no value was ever drawn. BIGINT sql The definition of this object, expressed as SQL DDL-statement. VARCHAR Attributes like temporary , start_value etc. correspond to the various options available in the CREATE SEQUENCE statement and are doc...umented there in full. Note that the attributes will always be filled out in the duckdb_sequences resultset, even if they were not explicitly specified in the CREATE SEQU... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Spatial Functions 7747
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...that are passed to the GDAL driver to control the opening of the file. E.g., the GeoJSON driver supports a FLATTEN_NESTED_ATTRIBUTES=YES option to flatten nested attributes. layer VARCHAR The name of the layer to read from the file. If NULL, the first lay... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- ODBC 101: A Duck Themed Guide to ODBC 7747
- What is ODBC? ODBC which stands for Open Database Connectivity, is a standard that allows different programs to talk to different databases including, of course, DuckDB. This makes it easier to build programs that work with many different d
...ed per connection. | Descriptor | Handle name | Descriptor | | Type name | SQL_HANDLE_DESC | | Description | Describes the attributes of a data structure or parameter, and allows the application to specify the structure of data to be bound/retrieved. | | U... - https://man.mtool.work/duckdb/2.0/guides/odbc/general.html
- Python Client API 7459
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...int ) → _duckdb._sqltypes.DuckDBPyType Create a decimal type with ‘width' and ‘scale' property description Get result set attributes, mainly column names df ( self , * , date_as_object : bool = False ) → object Fetch a result as DataFrame following execut...ed by the module duckdb. description ( * , connection : _duckdb.DuckDBPyConnection | None = None ) → object Get result set attributes, mainly column names duckdb. df ( df : object = None , * , date_as_object : bool = False , connection : DuckDBPyConnection... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work