#sql_commands_in_sap

[prince19007-blog]

There are many SQL commands which are used in sap abap. Some are below:

1 SELECT STATEMENT AND IT’S TYPES:2 SELECT SINGLE:3 SELECT UPTO n ROWS:4 SELECT with JOINS:5 INNER JOIN:6 OUTER JOIN:7 LEFT OUTER JOIN:8 RIGHT OUTER JOIN:9 Use of FOR ALL ENTRIES:10 …INTO CORRESPONDING FIELDS: 11 SELECT DISTINCT:12 SELECT WITH BYPASSING BUFFER:13 SELECT APPENDING:14 SQL SELECT STATEMENT CLAUSES:15 WHERE CLAUSE:16 GROUP BY:17 HAVING Clause: 18 …