Results of 1 - 10 of about 34 for equal (0.002 sec.)
- Comparisons 14779
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...2 > 3 false <= less than or equal to 2 <= 3 true >= greater than or equal to 4 >= NULL NULL = or == equal NULL = NULL NULL <> or != not equal 2 <> 2 false T...he table below shows the standard distinction operators. These operators treat NULL values as equal. Operator Description Example Result IS DISTINCT FROM not equal, including NULL 2 IS DISTINCT FROM NULL true IS NOT DISTIN...CT FROM equal, including NULL NULL IS NOT DISTINCT FROM NULL true Combination Casting When performing comparison on different types, Duc... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- Caveats 11487
- Equality Comparison Warning Currently, equality comparison of JSON files can differ based on the context. In some cases, it is based on raw text comparison, while in other cases, it uses logical content comparison. The following query retur
...ns true for all fields: SELECT a != b, -- Space is part of physical JSON content. Despite equal logical content, values are treated as not equal. c != d, -- Same. c[0] = d[0], -- Equality because space was removed from...physical content of fields: a = c[0], -- Indeed, field is equal to empty list without space... b != c[0], -- ... but different from empty list with space. FROM ( SELECT '[]'::JSON AS a,... - https://man.mtool.work/duckdb/2.0/data/json/caveats.html
- Keywords and Identifiers 10401
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...CT unnest({'a': 42, 'b': {'a': 88, 'b': 99}}, recursive := true)); a a_1 b 42 88 99 Identifier Resolution Identifiers can be qualified to remove ambiguity. A fully qualified column reference has the form ⟨database⟩.⟨schema⟩.⟨table⟩.⟨column⟩ , and any...leading part can be omitted when the remaining name is unambiguous. Table names can likewise be qualified as ⟨database⟩.⟨schema⟩.⟨table⟩ . When a name is not fully qualified, DuckDB resolves it using the catalog search pat...atabase and schema names are resolved, including the default database and schema and how to change the search path, see Name Qualification on the ATTACH page. Database Names Database names are subject to the rules for identifiers . Additionally, it is... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Samples 10273
- Samples are used to randomly select a subset of a dataset. Examples Select a sample of exactly 5 rows from tbl using reservoir sampling: SELECT * FROM tbl USING SAMPLE 5; Select a sample of approximately 10% of the table using system sampli
...ds reservoir Reservoir sampling is a stream sampling technique that selects a random sample by keeping a reservoir of size equal to the sample size, and randomly replacing elements as more elements come in. Reservoir sampling allows us to specify exac...ampling percentage is specified. It is rather straightforward: every row in the underlying table is included with a chance equal to the specified percentage. As a result, bernoulli sampling can return a different number of tuples even if the same perc...entage is specified. The expected number of rows is equal to the specified percentage of the table, but there will be some variance . Because bernoulli sampling is completely indep... - https://man.mtool.work/duckdb/2.0/sql/samples.html
- Subqueries 8691
- 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
...ALL , ANY and SOME In the section on scalar subqueries , a scalar expression was compared directly to a subquery using the equality comparison operator ( = ). Such direct comparisons only make sense with scalar subqueries. Scalar expressions can still...valuate to true : SELECT 6 <= ALL (SELECT grade FROM grades) AS adequate; returns: adequate true because 6 is less than or equal to each of the subquery results 7, 8 and 9. However, the following query SELECT 8 >= ALL (SELECT grade FROM grades) AS exc...ellent; returns excellent false because 8 is not greater than or equal to the subquery result 9. And thus, because not all comparisons evaluate to true , >= ALL as a whole evaluates to false .... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- List Type 8324
- A LIST column encodes lists of values. Fields in the column can have values with different lengths, but they must all have the same underlying type. LIST s are typically used to store arrays of numbers, but can contain any uniform data type
...LEAN values . The LIST ordering is defined positionally using the following rules, where min_len = min(len(l1), len(l2)) . Equality. l1 and l2 are equal, if len(l1) = len(l2) and for each i in [1, min_len] : l1[i] = l2[i] . Less Than . For the first i...ndex i in [1, min_len] where l1[i] != l2[i] : If l1[i] < l2[i] , l1 is less than l2 . If all values are equal, then the longer list sorts last. NULL values are compared following PostgreSQL's semantics: At the top level, comparisons... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- Text Functions 8212
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...the first character of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Alias for to_base64 . bin(string) Converts the strin...) | | Result | 937 | bar(x, min, max[, width]) | Description | Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. | | Example | bar(5, 0, 20, 10) | | Result | ██▌ | bin(string) |..., s2) The Hamming distance between two strings, i.e., the number of positions with different characters for two strings of equal length. Strings must be of equal length. Characters of different cases (e.g., a and A ) are considered different. jaccard(... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- WHERE Clause 8212
- The WHERE clause specifies any filters to apply to the data. This allows you to select only a subset of the data in which you are interested. Logically the WHERE clause is applied immediately after the FROM clause. Examples Select all rows
...where the id is equal to 3: SELECT * FROM tbl WHERE id = 3; Select all rows that match the given case-sensitive LIKE expression: SELECT * FROM t... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/where.html
- inet Extension 8084
- The inet extension defines the INET data type for storing IPv4 and IPv6 Internet addresses. It supports the CIDR notation for subnet masks (e.g., 198.51.100.0/22 , 2001:db8:3c4d::/48 ). Installing and Loading The inet extension will be tran
...127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::ffff:ffff/96 <<= Predicate Is subnet contained by or equal to subnet? CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.0/24'), ('127.0.0.1'), ('2001:db8:3c4d:15::1a2...et_contained 192.168.1.0/24 true 127.0.0.1 false 2001:db8:3c4d:15::1a2f:1a2b/96 false >>= Predicate Does subnet contain or equal subnet? CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.0/24'), ('127.0.0.1'), ('2001:db8:3c4d:15::1a2f:1... - https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
- Struct Data Type 8084
- Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys.
...antics : corresponding entries are compared position by position, and two NULL entries in the same position are considered equal (not distinct) so the comparison moves on to the next position. For ordering purposes, a NULL entry is treated as larger t...NULL value. Specifically: If every entry of s1 is not distinct from the corresponding entry of s2 (treating two NULL s as equal), then s1 and s2 compare equal. else, for the first index i where s1.value[i] is distinct from s2.value[i] , if s1.value[i... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
DuckDB 2.0 Documentation / man.mtool.work