Loading

select age in between

JAYRAM

i have table like this .........

sno name age
1 raju 23
2 praveen 56
3 kiran 36
4 vamshi 69
5 kumar 78
6 karthik 19

i wnt select only 18 -35 age names .........

1 raju 23
3 karthik 19

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak12y ago
Accepted answer
select * from tab2 where age between 18 and 35

or

select * from tab2 where age > 18 and age < 35
santosh choudhury12y ago
select sno,name,age from (your table name) where age between 18 and 35