database/ORACLE

between A and B

공간사랑 2015. 11. 30. 09:53

 

SELECT * FROM TABLE1 WHERE SEQ_NUM BETWEEN 1000 AND 2000;

 

 

SELECT * FROM TABLE1 WHERE SEQ_NUM>=1000 AND SEQ_NUM<=2000;