⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 4 of about 4 for nice (0.002 sec.)
COMMENT ON Statement 12426
The COMMENT ON statement allows adding metadata to catalog entries (tables, columns, etc.). It follows the PostgreSQL syntax . Examples Create a comment on a TABLE : COMMENT ON TABLE test_table IS 'very nice table'; Create a comment on a CO ... LUMN : COMMENT ON COLUMN test_table.test_table_column IS 'very nice column'; Create a comment on a VIEW : COMMENT ON VIEW test_view IS 'very nice view'; Create a comment on an INDEX : COMMEN ... T ON INDEX test_index IS 'very nice index'; Create a comment on a SEQUENCE : COMMENT ON SEQUENCE test_sequence IS 'very nice sequence'; Create a comment on a ... TYPE : COMMENT ON TYPE test_type IS 'very nice type'; Create a comment on a MACRO : COMMENT ON MACRO test_macro IS 'very nice macro'; Create a comment on a MACRO TABLE : ...
https://man.mtool.work/duckdb/2.0/sql/statements/comment_on.html
Utility Functions 8506
Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet ... rovided by the autocomplete extension. error(message) Throws the given error message . equi_width_bins(min, max, bincount, nice := false) Returns the upper boundaries of a partition of the interval [min, max] into bin_count equal-sized subintervals ( ... for use with, e.g., histogram ). If nice = true , then min , max and bincount may be adjusted to produce more aesthetically pleasing results. force_checkpoint(data ... | Description | Throws the given error message . | | Example | error('access_mode') | equi_width_bins(min, max, bincount, nice := false) | Description | Returns the upper boundaries of a partition of the interval [min, max] into bin_count equal-size ...
https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
Analyzing a Git Repository 8118
You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc ... -log.csv', delim = '?', header = false, column_names = ['timestamp', 'hash', 'author', 'message'] ); This will result in a nice DuckDB table: FROM commits LIMIT 5; ┌──────────────────────────┬────────────┬──────────────────┬────────────────────────── ...
https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
Aggregate Functions 7914
Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret ... ional technique argument selects the binning method and is one of auto , sample , equi-height , equi-width , or equi-width-nice . The optional bin_count argument sets the number of bins. | | Example | histogram_values(integers, i, bin_count := 2) | l ...
https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work