SELECT 语句
SELECT 是一个 Open-SQL 语句,用于将数据从一个或多个数据库表读取到数据对象中 。
-
选择所有记录
placeholderCopy
* This returns all records into internal table lt_mara. SELECT * FROM mara INTO lt_mara.
-
选择单个记录
placeholderCopy
* This returns single record if table consists multiple records with same key. SELECT SINGLE * INTO TABLE lt_mara FROM mara WHERE matnr EQ '400-500'.
-
选择不同的记录
placeholderCopy
* This returns records with distinct values. SELECT DISTINCT * FROM mara INTO TABLE lt_mara ORDER BY matnr.
-
聚合函数
placeholderCopy
* This puts the number of records present in table MARA into the variable lv_var SELECT COUNT( * ) FROM mara INTO lv_var.