Beware when using 'FOR ALL ENTRIES' in select statement. Although this addition to the select statement is an efficient...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
way to fetch distinct records from DB table, follow the below steps to ensure data consistency and efficiency.
1. Sort the Internal table used in the 'FOR ALL ENTRIES IN' clause. 2. make sure they do not contain duplicates. 3. last and most importantly include a primary key field(Unique entry) in the select list. The reason, the system gets unique field records based on the where condition. It summarizes the data based on the Data type and field list in the target internal table.