Home >> Oracle >> BETWEEN in Oracle

BETWEEN in Oracle

The BETWEEN used to fetch values within a given range.
The BETWEEN provides begin and end values.

Syntax

SELECT column1,column2 FROM tablename WHERE column1 BETWEEN startvalue AND endvalue

Example

SELECT * FROM faculty WHERE faculty_id BETWEEN 1 AND 5

Post Your Comment

Next Questions
EXISTS
NOT EXITS
ANY
ALL
MAX
MIN
AVG
COUNT
SUM
What is key
What is Super Key
What is Candidate Key
What is Primary Key
What is Unique Key
What is Foreign Key
Function
Procedure
Cursor
Trigger
Before Trigger
After Trigger
DROP Trigger
DISABLE Trigger
ENABLE Trigger
Aggregate Functions

Copyright ©2022 coderraj.com. All Rights Reserved.