Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

record between two numbers

Tony007May 10 2022

hi am in oracle 12c i need employee
between 12-369-4531 and
01-647-4207

i try this
select * from employee
where emp_no between '3694531 ' and '6474207'
and emp_code in ('12','01')
order by ncb_code;

Comments
Post Details
Added on May 10 2022
6 comments
636 views