Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Selection question

Hello everyone!

I need to select a db table to have this result:

-------------     -------------
| A | B | C |     | A | D | E |
|-----------|     |-----------|
| 1 | A | A |     | 1 | A | A |
| 2 | B | B |     | 2 | B | B |
| 3 | C | C |     -------------
-------------

RESULT
--------------------
| A | B | C | D | E |
|-------------------|
| 3 | C | C |   |   |
---------------------

OR 

-------------
| A | B | C |
|------------
| 3 | C | C |
-------------

How do I accomplish this?

I accomplish this by using loops to delete the duplicate entries. Is it possible to be selected in one SELECT statement?

Thanks a lot!

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question