>>>I have table namely "master_py_engg" having fields with 1.Regno(C) 2. Name(C) 3. Category(C) 4. Age(I). The category field contain the value 1. GE 2. MBC 3. OBC 4. SC.
>>>
>>>I want to select the age > 21 for category equal to (GE,MBC,OBC) and select age > 24 for category equal to (SC).
>>>
>>>awaiting yours valuable reply
>>
>>
>>select * from Master_py_Engg where Age >21 AND Category IN ('GE','MBC', 'OBC');
>> OR Age > 24 AND Category = 'SC'
>>
>
>Probably need parentheses around the ORed expression.
no.
You can think AND as Multiply and OR as Sum.