Page 1 of 1

Criteria based selection of a column value

PostPosted: Sun Jul 14, 2013 6:56 pm
by saurabhgupta86
Hi,

I have a table like below:

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

Re: Criteria based selection of a column value

PostPosted: Mon Jul 15, 2013 1:05 am
by dick scherrer
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.