1 SELECT * FROM PCSHD_PARAM_CONF 2 WHERE ST_ID BETWEEN 'ML' AND 'OS' 3* ORDER BY ST_ID SQL> /ST_ID CYC_TIME CAPACITY OWNER MOVE_TIME ---------- ---------- ---------- --------------- ---------- ML 1 8000 ML 1 NC 1.5 8000 ML 1 OS 1 8000 OS 1BETWEEN 包括本身的!如果要不包括本身可以如下下: 1 SELECT * FROM PCSHD_PARAM_CONF 2 WHERE ST_ID BETWEEN 'ML' AND 'OS' 3 AND ST_ID<>'ML' 4 AND ST_ID<>'OS' 5* ORDER BY ST_ID SQL> /ST_ID CYC_TIME CAPACITY OWNER MOVE_TIME ---------- ---------- ---------- --------------- ---------- NC 1.5 8000 ML 1
可不可以做成两个记录集,然后合并呢??
2 WHERE ST_ID BETWEEN 'ML' AND 'OS'
3* ORDER BY ST_ID
SQL> /ST_ID CYC_TIME CAPACITY OWNER MOVE_TIME
---------- ---------- ---------- --------------- ----------
ML 1 8000 ML 1
NC 1.5 8000 ML 1
OS 1 8000 OS 1BETWEEN 包括本身的!如果要不包括本身可以如下下:
1 SELECT * FROM PCSHD_PARAM_CONF
2 WHERE ST_ID BETWEEN 'ML' AND 'OS'
3 AND ST_ID<>'ML'
4 AND ST_ID<>'OS'
5* ORDER BY ST_ID
SQL> /ST_ID CYC_TIME CAPACITY OWNER MOVE_TIME
---------- ---------- ---------- --------------- ----------
NC 1.5 8000 ML 1