- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Fetch unique records from table in SAP ABAP
As you said you are working in ABAP and SQL, so I would expect that you would be using OpenSQL for your SQL activities.
You can get the unique records just by using a DISTINCT operator.
SELECT DISTINCT Name from <Table name> where <clause>
- Related Articles
- Fetch fields from table or structure in ABAP SAP
- Retrieving data from a table in SAP ABAP
- How can we fetch alternate even-numbered records from MySQL table?
- How can we fetch alternate odd numbered records from MySQL table?
- How to fetch the newly added records from a MySQL table?
- Hiding SAP ABAP table control column
- In SAP ABAP, few records are skipped during parallel processing
- How can fetch records from specific month and year in a MySQL table?
- How can we fetch all the records from a particular MySQL table?
- In SAP ABAP, mapping two database table fields
- MySQL query to fetch the latest date from a table with date records
- Fetch the modified date of table in SAP HANA
- Retrieving ABAP BAdi from SAP BW
- Modification not working for both internal table and control table in SAP ABAP
- Fetch similar ID records from two tables in MySQL
Advertisements