● 관계 연산자 ( and , or , between , in , not ) > ORACLE

• 목록

● 연산자 : not , and , or , between , in 

01. select * from notice;

02. select * from notice where hit=0 or hit=100;

03. select * from notice where hit in(0,100); 

04. select * from notice where hit not in(0,100); 

05. select * from notice where 50<=hit and hit<=100;

06. select * from notice where hit between 50 and 100;