IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Criteria based selection of a column value



IBM's flagship relational database management system
Post a reply

Criteria based selection of a column value

Postby saurabhgupta86 » Sun Jul 14, 2013 6:56 pm

Hi,

I have a table like below:

Select all
ID     SER      DESG
1      111       Manager
2      112      ASST MGR
3       221     CLERK
4       222      CLERK
5       223       ENGG
6       333       ENGG


I want to read all the records in the table, except DEGN column value [/b]but want to read DESG column value ONLY in case ID IS between 1 to 4 and SER IS between 112 to 222. Please suggest.

Regards,
Saurabh
saurabhgupta86
 
Posts: 13
Joined: Tue Aug 14, 2012 6:35 pm
Has thanked: 1 time
Been thanked: 0 time
Top

Re: Criteria based selection of a column value

Postby dick scherrer » Mon Jul 15, 2013 1:05 am

Hello,

Suggest you learn to use the Code tag . . .

What is DEGN?

Suggest you Post the "output" you want when the query is run. What is posted is not clear.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks