>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'