SELECT * FROM myTable WHERE (id > 20) AND (id < 50);