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>