unable to make out use of BETWEEN in oracle
Posted
by Ankit Sachan
on Stack Overflow
See other posts from Stack Overflow
or by Ankit Sachan
Published on 2010-03-07T20:56:15Z
Indexed on
2010/03/08
3:51 UTC
Read the original article
Hit count: 472
I am not able to make this out: Between eliminates use of >= and <=
...but when i tried this query:
SELECT *
FROM names
WHERE name >= 'Ankit'
AND name <= 'P'
...it gives output:
name
------
Ankit
Mac
Bob
When I tried:
SELECT *
FROM names
WHERE name BETWEEN 'Ankit' AND 'P'
...it gives output:
name
------
Ankit
Can you explain this why?
© Stack Overflow or respective owner