SELECT DISTINCT 语句会去重,只返回不同的记录。SELECT DISTINCT 语句可以使用 WHERE 子句指定查询条件,也可以使用 GROUP BY 子句和 HAVING 子句进行分组和聚合操作。SELECT DISTINCT 语句的基本语法如下: 代码语言:javascript 复制 SELECTDISTINCT<fields>INTO<internal table>FROM<data source>[WHERE<condition>][GROUPBY<...
能给一个具体点的列子说明下么? distinct 去掉重复的 取唯一。 不过abap里 这个效率不是很高。spfli 是系统(System)内用来做演示的1个表 sql 中DISTINCT使用如:SELECT DISTINCT 列名称 FROM 表名... select distinct empno as 别名 from 表名; 潍坊个人出售二手车-上[58同城]二手车平台 [58同城]本地二手车,...
distinct 去掉重复的 取唯一。 不过abap里 这个效率不是很高。spfli 是系统内用来做演示的一个表
SELECT-OPTIONS ( SAP ABAP Keyword) SELECT-OPTIONS is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details. SELECT-OPTIONS Basic formSELECT-OPTIONS sel... EXEC (ABAP Keyword) EXEC (ABAP Keyword) introduction & syntax details EXEC Basic formEXEC SQL. Addit...
SELECT DISTINCT (FTAB) INTO CORRESPONDING FIELDS OF SPFLI FROM SPFLI WHERE CARRID = ‘LH’. WRITE: / SPFLI-CITYFROM, SPFLI-CITYTO. ENDSELECT. SELECT ( SAP ABAP Keyword) SELECT is a keyword used in SAP ABAP programming.This tutorial covers its introduction & syntax details. SELECT Basic fo...
注:使用DISTINCT自动去掉重复的行;SY-DBCNT(系统字段)为每次循环计数;对三塔tement block中语句块进行处理。 2.选择至内表 克刚变得一次性把数据选择到一个内表中去。 SELECT ...INTO|APPENDING[CORRESPONDING FIELDS OF]TABLE itab. 注:该情况下SELECT并不启动循环,因而不需要使用ENDSELECT语句;如果itab非空,则...
[[FOR ALL ENTRIES IN itab]WHEREsql_cond] [GROUP BYgroup][HAVINGgroup_cond] [UNION[ALL|DISTINCT]select] [ORDER BYsort_key] INTO|APPENDINGtarget [additional_options]. ... [ENDSELECT]. Effect SELECTis the Open SQL statement for reading data from one or moredatabase tables,classic views, or...
Whenpooled tablesorcluster tablesare accessed dynamically, the use of the additionDISTINCTraises a handleable exception. Ifcolumn_syntaxis an internal table with aheader line, thetable bodyis evaluated, and not the header line. The classCL_ABAP_DYN_PRGcontains methods that support the creation of...
SAP Managed Tags: ABAP Development I was waiting desperately a simple answer for this simple problem. Unfortunately, all simple problems don't have yet a simple solution. My code in one line (NO it's not cheating ) : get_distinct_values : it_vbak ernam lt_ernam. with the following...
SELECT COUNT( DISTINCT CARRID ) INTO COUNT FROM SPFLI WHERE CITYTO = 'NEW YORK'. They can avoid endselect . Sail Reply gopi_narendra Active Contributor 2007 Sep 05 5:05 AM 0 Kudos 4,509 SAP Managed Tags: ABAP Development select endselect is just like a select with in a...