Write a Sql & Revert me ASAP !

IBM's flagship relational database management system

Write a Sql & Revert me ASAP !

Postby aryanics » Thu Sep 30, 2010 9:16 am

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
Posts: 1
Joined: Thu Sep 30, 2010 9:05 am
Has thanked: 0 time
Been thanked: 0 time

Re: Write a Sql & Revert me ASAP !

Postby dick scherrer » Thu Sep 30, 2010 9:30 am

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.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post