Select with Appending

We can directly append records into an internal table with select statement by using APPENDING clause. Syntax is as follows. SELECT db_...

Select Total Field Records

How to select total records from one or more than one fields from database? We can do that by not using the WHERE condition as simple as...

Select Distinct

Select distinct only selects the unique entries of the fields in the select statement. It will not allow any duplicate entry into the inte...

Select Single and Select up to

Select single statement only selects the first record of any series of records from a database table. That means this statement can read a...

Collect Statement

COLLECT statement can be used in the internal table whose non key fields are all numeric. It means the statement finds the key (non numeri...

Delete Adjacent Duplicate

DELETE ADJACENT DUPLICATE statement works logically on sorted standard table and sorted table with non-unique key . It compares the adjace...