ABAP编程指南：使用SELECT DISTINCT与聚合函数处理数据.pptxVIP

REPORTY170DM72.TABLES:TABNA.DATA:CNTRYLIKETABNA-COUNTRY.SELECTDISTINCTCOUNTRY FROMTABNAINTO(CNTRY). WRITE:/CNTRY.ENDSELECT.TheSELECTDISTINCTStatementUsingSELECTDISTINCT,it

ispossible

toeliminateduplicaterowsfromthe

resultset.

SELECTUsingAggregateFunctionsREPORTY170DM73.TABLES:TABNA.DATA: TOTALTYPEI, MAX_SALESLIKETABNA-SALES, AVG_SALESLIKETABNA-SALES, MIN_SALESLIKETABNA-SALES.SELECT COUNT(DISTINCTCOUNTRY) MAX(SALES) AVG(SALES) MIN(SALES)FROMTABNAINTO(TOTAL,MAX_SALES,AVG_SALES,MIN_SALES)WHERECOUNTRYSPACE. WRITE:/‘TableTABNAStatistics’, /TOTAL,‘DifferentCountries’, /8MIN_SALES,‘LowestSales’, /8AVG_SALES,‘AverageSales’, /8MAX_SALES,‘HighestSales’.

TheDynamicWHEREClauseREPORTY170DM74.TABLES:TABNA.PARAMETERS: WHERECL1(72)DEFAULT‘COUNTRY=‘‘USA’’’, WHERECL2(3)DEFAULT‘OR’, WHERECL3(72)DEFAULT‘COUNTRY=‘‘GB’’’.TYPE: BEGINOFITAB_RECORD,TEXT(72), ENDOFITAB_RECORD.DATA:WHERE_ITABTYPESTANDARDTABLEOFITAB_RECORDINITIALSIZE3WITHHEADERLINE.WHERE_ITAB-TEXT=WHERECL1.APPENDWHERE_ITAB.WHERE_ITAB-TEXT=WHERECL2.APPENDWHERE_ITAB.WHERE_ITAB-TEXT=WHERECL3.APPENDWHERE_ITAB.SELECT*FROMTABNAWHERE(WHERE_ITAB). WRITE:/TABNA-COUNTRY,TABNA-ID.ENDSELECT.TheparametersenteredmakeupthecontentsoftheWHEREclause.Theuserhastheoptionofchangingtheconditionsanddynamicallyeffectingwhichwaytheprogramwillexecute.AninternaltableiscreatedwhichholdstheWHEREclauseuntilitisusedintheSELECTstatement.

CONCATENATEStatementREPORTY170DM74.TABLES:TABNA.PARAMETERS: WHERECL1(72)DEFAULT‘COUNTRY=‘‘USA’’’, WHERECL2(3)DEFAULT‘OR’, WHERECL3(72)DEFAULT‘COUNTRY=‘‘GB’’’.TYPE:BEGINOFITAB_RECORD, TEXT(72), ENDOFITAB_RECORD.DATA:WHERE_ITABTYPESTANDARDTABLEOFITAB_RECORDINITIALSIZE3WITHHEADERLINE.CONCATENATEWHERECL1WHERECL2WHERECL3 INTOWHERE_ITAB-TEXTSEPARATEDBYSPACE.AP