IBM Mainframe Forum

[aryanics]

Table T1

col1 col2 col3
------------------------
a dd1 dd2
c dd5 dd6
a dd3 dd4
d dd7 dd8
a dd9 dd10

Give me a generic solution ! the result should be

a dd1 dd2
a dd3 dd4
a dd9 dd10

[dick scherrer]

Hello and welcome to the forum,

For starters, we don't do asap.

We also don't respond well to "give me".

What in the world is a "generic solution" for this

What have you tried or did you try nothing at all? What have you learned about a SELECT? Among the first things learned is the list of columns to be returned and the criteria by which rows are selected (the WHERE).

Suggest you apply this and write some sql code. Reply back here if there are questions or problems.