select between age and gender

Question

I HAVE TABLE LIKE THIS.............

SNO NAME AGE GENDER
1 RAMU 19 MALE
2 PRAVEEN 25 MALE
3 AKILA 18 FEMALE
4 RAJU 29 MALE
5 PRAVEEN 34 MALE
6 ROJA 22 FEMALE

I WANT O/P LIKE BELOW

select onle age between 18 to 25 males only......

ex;-
sno name age gender
1 RAMU 19 MALE
2 PRAVEEN 25 MALE

dinesh vasamshetty · Answer

use following sql query: select *from tablename where gender='MALE' and age between 19 and 25;

Sanjay Dholakiya · Answer

Hi Try this. Select * from YourTableName Where (Age >18 and Age or Select * from YourTableName Where (Age between 18 and 26) And Gender = 'Male' - Sanjay Dholakiya

Vulpes · Answer

This query should return just RAMU's record: select * from tablename where name like 'R%' and gender='MALE' and age between 19 and 25;

JAYRAM · Answer

thanx ........... in above table compare two coloums only....k but how to compare 3 coloums .... like name age gender ???????????????????????????