between A and B

database/ORACLE 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;

 


 

Posted by 공간사랑
,