ABAP sql

1.取最大 SELECT SINGLE MAX( begda ) INTO @DATA(lv_max_begda) FROM pa0530.
2.限制行数 UP TO 1 ROWS.
3.FILTER DATA(lt_result) = FILTER #( itab WHERE start_date > '20250101' ).
4..CAST 函数: Data Type Conversion Function

CAST (expression AS data_type)
CAST( 列名/值/表达式 AS 数据类型)
范例:

参数为列名: select CAST(empno as INTEGER) as EMPNO from emp;

参数为值:select CAST('23456' as INTEGER) as "CAST" from DUMMY;

参数为子查询: select CAST((select top 1 empno from emp) as INTEGER) from DUMMY;

posted @ 2025-08-26 10:02  zcy651261539  阅读(7)  评论(0)    收藏  举报