Arithmetic operations in where clause
Operations like addition, subtraction and multiplication are allowed between fields in the where clause.
SELECT movie FROM zmmovie
WHERE ( grosscol - openingcol ) > 10000000
INTO TABLE @DATA(lt_movie).
Serkan AKKAVAK
Computer Engineer BSc
SAP Department Deputy Manager
Contact : serkurumsal@yandex.com
0 Comments