#openGauss #入门 #安装 #数据库 #开源
知识来源：docs-opengauss.osinfra.cn/zh/
示例
-
读取表customer_t1中所有的数据。
yaml复制代码openGauss=# SELECT * FROM customer_t1; c_customer_sk | c_customer_id | c_first_name | c_last_name | amount ---------------+---------------+--------------+-------------+-------- 3869 | hello | Grace | | 1000 3869 | hello | Grace | | 1000 3869 | | Grace | | 3869 | hello | | | 3869 | hello | | | | | | | 6985 | maps | Joes | | 2200 9976 | world | James | | 5000 4421 | Admin | Local | | 3000 (9 rows) -
读取表customer_t1中指定字段c_customer_sk、c_customer_id。
sql复制代码openGauss=# SELECT c_customer_sk,c_customer_id FROM customer_t1; c_customer_sk | c_customer_id ---------------+--------------- 3869 | hello 3869 | hello 3869 | 3869 | hello 3869 | hello | 6985 | maps 9976 | world 4421 | Admin (9 rows)
#openGauss #入门 #安装 #数据库 #开源