--비교연산자 like ,between and , inselect*fromEMP02_EMPwhereemp02_person_id like '%2'; select*fromEMP02_EMPwhereemp02_emp_id between 2000001 and 2000032; select*fromEMP02_EMPwhereemp02_emp_id in (2000001, 2000002, 2000003); select*fromEMP02_EMPorder by emp02_note desc;--컬럼의 별칭을 통한 정렬selectemp02_emp_id 사원fromEMP02_EMPorder by 사원; select emp02_emp_id, emp02_person_id, emp02_emp_nofromEMP02_EMPorder by ..