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;

 


 

반응형