Limiting Rows Returned in SQL Statements in Oracle 19c
Oracle 19c Applying Rules of precedence for operators in an expression
Restricting and Sorting Data in Oracle 19c