WITH temp AS
(
SELECT LEVEL lv FROM dual CONNECT BY LEVEL< 50
)
SELECT * FROM temp WHERE lv BETWEEN 20 AND 30;
--BETWEEN..and =[]
WITH temp AS
(
SELECT LEVEL lv FROM dual CONNECT BY LEVEL< 50
)
SELECT * FROM temp WHERE lv BETWEEN 20 AND 30;
--BETWEEN..and =[]