Results of 1 - 7 of about 7 for percent (0.005 sec.)
- Pattern Matching – DuckDB 12250
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...f LIKE returns true , and vice versa. An equivalent expression is NOT (string LIKE pattern) .) If pattern does not contain percent signs or underscores, then the pattern only represents the string itself; in that case LIKE acts like the equals operator....An underscore ( _ ) in pattern stands for (matches) any single character; a percent sign ( % ) matches any sequence of zero or more characters. LIKE pattern matching always covers the entire string. Therefo...re, if it's desired to match a sequence anywhere within a string, the pattern must start and end with a percent sign. Some examples: SELECT 'abc' LIKE 'abc' ; -- true SELECT 'abc' LIKE 'a%' ; -- true SELECT 'abc' LIKE '_b_' ; -- true... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Samples – DuckDB 11305
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ately 10% of the table using system sampling: SELECT * FROM tbl USING SAMPLE 10 % ; Warning By default, when you specify a percentage, each vector is included in the sample with that probability. If your table contains fewer than ~10k rows, it makes sen...lies the probability to each row independently. Even then, you'll sometimes get more and sometimes less than the specified percentage of the number of rows, but it is much less likely that you get no rows at all. To get exactly 10% of rows (up to roundi...ling option. Select a sample of approximately 10% of the table using bernoulli sampling: SELECT * FROM tbl USING SAMPLE 10 PERCENT ( bernoulli ); Select a sample of exactly 10% (up to rounding) of the table using reservoir sampling: SELECT * FROM tbl US... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- Window Functions – DuckDB 8706
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...current and the previous-by- time amount : SELECT amount - lag ( amount ) OVER ( ORDER BY time ) FROM sales ; Compute the percentage of the total amount of sales per region for each row: SELECT amount / sum ( amount ) OVER ( PARTITION BY region ) FROM...num_buckets[ ORDER BY ordering]) An integer ranging from 1 to num_buckets , dividing the partition as equally as possible. percent_rank([ORDER BY ordering]) The relative rank of the current row: (rank() - 1) / (total partition rows - 1) . rank_dense() T...s computed within the frame using the provided ordering instead of the frame ordering. Return type BIGINT Example ntile(4) percent_rank([ORDER BY ordering]) Description The relative rank of the current row: (rank() - 1) / (total partition rows - 1) . If... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Text Functions – DuckDB 8469
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...in the string . upper(string) Converts string to upper case. url_decode(string) Decodes a URL from a representation using Percent-Encoding . url_encode(string) Encodes a URL to a representation using Percent-Encoding . string[index] Description Extract.... Example upper('Hello') Result HELLO Alias ucase url_decode(string) Description Decodes a URL from a representation using Percent-Encoding . Example url_decode('https%3A%2F%2Fduckdb.org%2Fwhy_duckdb%23portable') Result https://duckdb.org/why_duckdb#por...table url_encode(string) Description Encodes a URL to a representation using Percent-Encoding . Example url_encode('this string has/ special+ characters>') Result this%20string%20has%2F%20special%2B%20charac... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Relational API – DuckDB 8233
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...n_tile Divides the partition as equally as possible into num_buckets nth_value Computes the nth value within the partition percent_rank Computes the relative rank within the partition product Returns the product of all values present in a given column q...value is uneven │ 1 │ │ value is uneven │ 1 │ └─────────────────┴───────────────────────────────────────────────────────┘ percent_rank Signature percent_rank ( self : duckdb . duckdb . DuckDBPyRelation , window_spec : str , projected_columns : str = ''...ription, range as value, now() + concat(range,' ', 'minutes')::interval as created_timestamp from range(1, 10) """ ) rel . percent_rank ( window_spec = "over (partition by description order by value)" , projected_columns = "description, value" ) Result... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Partitioned Writes – DuckDB 7761
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...UUID in the rare event that it does (to avoid clashes). Handling Slashes in Columns To handle slashes in column names, use Percent-Encoding implemented by the url_encode function . 関連キーワード orders files parquet partitioned month year Hive Write ta... - https://man.mtool.work/duckdb/1.3/data/partitioning/partitioned_writes.html
- Python Client API – DuckDB 6815
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...uckdb.DuckDBPyRelation ¶ Reorder the relation object by order_expr Detailed examples can be found at Relational API page . percent_rank ( self : duckdb.duckdb.DuckDBPyRelation , window_spec : str , projected_columns : str = '' ) → duckdb.duckdb.DuckDBPy... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work