need a sql

[vandanasridhar]

Can somebody send me sql querry for selecting candidates who are applying for the post of Engineer,having salary between 1000 to 5000,experience between 3.0 to 5.0, qualification b.tech
while my structre of table is as below:


name text
fname text
qualification text
post1 text
post2 text
post3 text
salary number
experience number(4,2)

[r035198x]

Can somebody send me sql querry for selecting candidates who are applying for the post of Engineer,having salary between 1000 to 5000,experience between 3.0 to 5.0, qualification b.tech
while my structre of table is as below:


name text
fname text
qualification text
post1 text
post2 text
post3 text
salary number
experience number(4,2)

Post your attempt at the query first.