a2h

You can try with the below code

 Select *
From   yourtablename
Where Age Between 30 And 35

Thanks for reply when i tried with between then it is not displaying the records whose age is 30  or 35 but between shows the records between 30 to 35. i also need those records whose age is 30 and 35.

Regards