思维导图备注

ClickHouse v21.2 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

SELECT

 来源:ClickHouse 浏览 252 扫码 分享 2021-03-09 00:08:08
  • Overview
  • ALL
  • ARRAY JOIN
  • DISTINCT
  • FORMAT
  • FROM
  • GROUP BY
  • HAVING
  • INTO OUTFILE
  • JOIN
  • LIMIT
  • LIMIT BY
  • ORDER BY
  • PREWHERE
  • SAMPLE
  • UNION
  • WHERE
  • WITH
  • INSERT INTO
当前内容版权归 ClickHouse 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 ClickHouse .
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • Introduction
    • Overview
    • Distinctive Features
    • Performance
    • History
    • Adopters
    • Information support
  • Getting Started
    • Example Datasets
      • Introduction
      • GitHub Events
      • Yandex.Metrica Data
      • Recipes Dataset
      • Star Schema Benchmark
      • WikiStat
      • Terabyte Click Logs from Criteo
      • AMPLab Big Data Benchmark
      • Brown University Benchmark
      • New York Taxi Data
      • Cell Towers
      • OnTime
    • Installation
    • Tutorial
    • Playground
  • Interfaces
    • Introduction
    • Command-Line Client
    • Native Interface (TCP)
    • HTTP Interface
    • MySQL Interface
    • Input and Output Formats
    • JDBC Driver
    • ODBC Driver
    • C++ Client Library
    • Third-Party
      • Third-Party Interfaces
      • Client Libraries
      • Integrations
      • Visual Interfaces
      • Proxies
  • Engines
    • Table Engines
      • Introduction
      • MergeTree Family
        • Introduction
        • MergeTree
        • Data Replication
        • Custom Partitioning Key
        • ReplacingMergeTree
        • SummingMergeTree
        • AggregatingMergeTree
        • CollapsingMergeTree
        • VersionedCollapsingMergeTree
        • GraphiteMergeTree
      • Log Family
        • Introduction
        • StripeLog
        • Log
        • TinyLog
      • Integrations
        • ODBC
        • JDBC
        • MySQL
        • HDFS
        • S3
        • Kafka
        • EmbeddedRocksDB
        • RabbitMQ
        • MongoDB
        • Table Engines for Integrations
      • Special
        • Special Table Engines
        • Distributed
        • Dictionary
        • Merge
        • File
        • Null
        • Set
        • Join
        • URL
        • View
        • MaterializedView
        • Memory
        • Buffer
        • External Data
        • GenerateRandom
    • Database Engines
      • Introduction
      • MaterializeMySQL
      • MySQL
      • Lazy
      • Atomic
  • SQL Reference
    • Statements
      • SELECT
        • Overview
        • ALL
        • ARRAY JOIN
        • DISTINCT
        • FORMAT
        • FROM
        • GROUP BY
        • HAVING
        • INTO OUTFILE
        • JOIN
        • LIMIT
        • LIMIT BY
        • ORDER BY
        • PREWHERE
        • SAMPLE
        • UNION
        • WHERE
        • WITH
        • INSERT INTO
      • CREATE
        • Overview
        • DATABASE
        • TABLE
        • VIEW
        • DICTIONARY
        • USER
        • ROLE
        • ROW POLICY
        • QUOTA
        • SETTINGS PROFILE
      • ALTER
        • ALTER
        • COLUMN
        • PARTITION
        • DELETE
        • UPDATE
        • ORDER BY
        • SAMPLE BY
        • INDEX
        • CONSTRAINT
        • TTL
        • USER
        • QUOTA
        • ROLE
        • ROW POLICY
        • SETTINGS PROFILE
        • SYSTEM
        • SHOW
        • GRANT
        • EXPLAIN
        • REVOKE
        • ATTACH
        • CHECK
        • DESCRIBE
        • DETACH
        • DROP
        • EXISTS
        • KILL
        • OPTIMIZE
        • RENAME
        • SET
        • SET ROLE
        • TRUNCATE
        • USE
        • WATCH
        • Syntax
        • Distributed DDL
    • Functions
      • Introduction
      • Arithmetic
      • Arrays
      • Array
      • Comparison
      • Logical
      • Type Conversion
      • Dates and Times
      • Strings
      • For Searching in Strings
      • For Replacing in Strings
      • Conditional
      • Mathematical
      • Rounding
      • Working with maps
      • Splitting and Merging Strings and Arrays
      • Bit
      • Bitmap
      • Hash
      • Pseudo-Random Numbers
      • Encoding
      • UUID
      • URLs
      • IP Addresses
      • JSON
      • External Dictionaries
      • Yandex.Metrica Dictionaries
      • IN Operator
      • arrayJoin
      • Geo
        • Geographical Coordinates
        • Geohash
        • H3 Indexes
        • Nullable
        • Machine Learning
        • Introspection
        • Tuples
        • Encryption
        • Other
    • Aggregate Functions
      • Introduction
      • Reference
        • count
        • min
        • max
        • sum
        • avg
        • any
        • stddevPop
        • stddevSamp
        • varPop(x)
        • varSamp
        • covarPop
        • covarSamp
        • anyHeavy
        • anyLast
        • argMin
        • argMax
        • avgWeighted
        • corr
        • topK
        • topKWeighted
        • groupArray
        • groupUniqArray
        • groupArrayInsertAt
        • groupArrayMovingSum
        • groupArrayMovingAvg
        • groupArraySample
        • groupBitAnd
        • groupBitOr
        • groupBitXor
        • groupBitmap
        • groupBitmapAnd
        • groupBitmapOr
        • groupBitmapXor
        • sumWithOverflow
        • deltaSum
        • sumMap
        • minMap
        • maxMap
        • initializeAggregation
        • skewPop
        • skewSamp
        • kurtPop
        • kurtSamp
        • uniq
        • uniqExact
        • uniqCombined
        • uniqCombined64
        • uniqHLL12
        • quantile
        • quantiles
        • quantileExact
        • quantileExactWeighted
        • quantileTiming
        • quantileTimingWeighted
        • quantileDeterministic
        • quantileTDigest
        • quantileTDigestWeighted
        • simpleLinearRegression
        • stochasticLinearRegression
        • stochasticLogisticRegression
        • categoricalInformationValue
        • studentTTest
        • welchTTest
        • mannWhitneyUTest
        • median
        • rankCorr
        • Combinators
        • Parametric
    • Table Functions
      • Introduction
      • file
      • merge
      • numbers
      • remote
      • url
      • mysql
      • jdbc
      • odbc
      • hdfs
      • s3
      • input
      • generateRandom
      • cluster
      • view
      • null function
    • Dictionaries
      • Introduction
      • External Dictionaries
        • General Description
        • Configuring an External Dictionary
        • Storing Dictionaries in Memory
        • Dictionary Updates
        • Sources of External Dictionaries
        • Dictionary Key and Fields
        • Hierarchical dictionaries
        • Polygon Dictionaries With Grids
        • Internal Dictionaries
    • Data Types
      • Introduction
      • UInt8, UInt16, UInt32, UInt64, UInt256, Int8, Int16, Int32, Int64, Int128, Int256
      • Float32, Float64
      • Decimal
      • Boolean
      • String
      • FixedString(N)
      • UUID
      • Date
      • DateTime
      • DateTime64
      • Enum
      • LowCardinality
      • Array(T)
      • AggregateFunction
      • Nested Data Structures
        • Nested(Name1 Type1, Name2 Type2, …)
        • Tuple(T1, T2, …)
        • Nullable
      • Special Data Types
        • Expression
        • Set
        • Nothing
        • Interval
      • Domains
        • Overview
        • IPv4
        • IPv6
        • Multiword Type Names
        • Geo
        • Map(key, value)
        • SimpleAggregateFunction
    • Operators
      • Operators
      • IN Operators
      • ANSI Compatibility
    • Window Functions
      • Window Functions
  • Guides
    • Overview
      • Applying CatBoost Models
  • Operations
    • Introduction
      • Requirements
      • Monitoring
      • Troubleshooting
      • ClickHouse Upgrade
      • Access Control and Account Management
    • External User Authenticators and Directories
      • Introduction
      • LDAP
      • Data Backup
      • Configuration Files
      • Quotas
    • Optimizing Performance
      • Query Profiling
    • System Tables
      • System Tables
      • system.asynchronous_metric_log
      • system.asynchronous_metrics
      • system.clusters
      • system.columns
      • system.contributors
      • system.crash_log
      • system.current_roles
      • system.data_type_families
      • system.databases
      • system.detached_parts
      • system.dictionaries
      • system.disks
      • system.distributed_ddl_queue
      • system.distribution_queue
      • system.enabled_roles
      • system.errors
      • system.events
      • system.functions
      • system.grants
      • system.graphite_retentions
      • system.licenses
      • system.merge_tree_settings
      • system.merges
      • system.metric_log
      • system.metrics
      • system.mutations
      • system.numbers
      • system.numbers_mt
      • system.one
      • system.opentelemetry_span_log
      • system.part_log
      • system.parts
      • system.parts_columns
      • system.processes
      • system.query_log
      • system.query_thread_log
      • system.quota_limits
      • system.quota_usage
      • system.quotas
      • system.quotas_usage
      • system.replicas
      • system.replicated_fetches
      • system.replication_queue
      • system.role_grants
      • system.roles
      • system.row_policies
      • system.settings
      • system.settings_profile_elements
      • system.settings_profiles
      • system.stack_trace
      • system.storage_policies
      • system.table_engines
      • system.tables
      • system.text_log
      • system.time_zones
      • system.trace_log
      • system.users
      • system.zookeeper
    • Server Configuration Parameters
      • Introduction
      • Server Settings
    • Testing Hardware
    • Settings
      • Introduction
      • Permissions for Queries
      • Restrictions on Query Complexity
      • Settings Profiles
      • Constraints on Settings
      • User Settings
      • MergeTree tables settings
      • Settings
    • Utilities
      • Overview
      • clickhouse-copier
      • clickhouse-local
      • clickhouse-benchmark
      • ClickHouse compressor
      • ClickHouse obfuscator
      • clickhouse-odbc-bridge
      • Usage Recommendations
      • OpenTelemetry Support
      • Caches
  • Development
    • For Beginners
    • Architecture Overview
    • Continuous Integration Checks
    • Build on Linux
    • Build on Mac OS X
    • Build on Linux for Mac OS X
    • Build on Linux for AARCH64 (ARM64)
    • C++ Guide
    • Testing
    • Third-Party Libraries Used
    • Source Code Browser
    • CMake in ClickHouse
    • How to add test queries to ClickHouse CI
  • Commercial
    • Cloud
    • Support
    • Introduction
  • F.A.Q.
    • General
      • Why ClickHouse is so fast?
      • Who is using ClickHouse?
      • What does “ClickHouse” mean?
      • What does “Не тормозит” mean?
      • What is OLAP?
      • What is a columnar database?
      • Why not use something like MapReduce?
    • Use Cases
      • Can I use ClickHouse as a time-series database?
      • Can I use ClickHouse as a key-value storage?
    • Operations
      • Which ClickHouse version to use in production?
      • Is it possible to delete old records from a ClickHouse table?
    • Integration
      • How do I export data from ClickHouse to a file?
      • How to import JSON into ClickHouse?
      • What if I have a problem with encodings when connecting to Oracle via ODBC?
  • What’s New
    • Changelog
      • 2021
      • 2020
      • 2019
      • 2018
      • 2017
    • Roadmap
    • Security Changelog
      • What’s New in ClickHouse?
暂无相关搜索结果！

    本文档使用 BookStack 构建

    展开/收起文章目录

    分享，让知识传承更久远

    文章二维码

    手机扫一扫，轻松掌上读

    文档下载

    • 普通下载
    • 下载码下载(免登录无限下载)
    你与大神的距离，只差一个APP
    APP下载
    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档
    温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
    下载码方式下载：免费、免登录、无限制。 免费获取下载码

    微信小程序阅读

    BookChat 微信小程序阅读
    您与他人的薪资差距，只差一个随时随地学习的小程序

    书签列表

      阅读记录

      阅读进度: 0.00% ( 0/0 ) 重置阅读进度