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