topic Query doubt.. in Application Development and Automation Discussions

Query doubt..

Former Member — Sat, 21 Jun 2008 18:39:40 GMT

Hello,

I have custom table as follows:

KEY-SOLE

K1 - A

K1 - B

K2 - A

K2 - C

K3 - C

K4 - D

Now I want to write a query which will select all unique SAP values in internal

table such that output will be:

Regards,

Rajesh.

Clemenss — Sat, 21 Jun 2008 19:41:57 GMT

Hi Rajesh,

hmm.

If it is a database table, you need to SELECT DISTINCT ...

If it is internal table,

you may INSERT all records into an other internal table with UNIQUE KEY <sole?>

Regards,

Clemens