SELECT col1,col2,col3,..... FROM tableName WHERE col1 IN (val1, val2, ...);
SELECT col1,col2,col3,..... FROM tableName WHERE col1 BETWEEN val1 AND val2;
SELECT col1,col2,col3,..... FROM tableName WHERE col1 IN (SELECT STATEMENT);