oracle過濾和排序數(shù)據(jù)(編輯修改稿)
2024-11-14 18:20 本頁面
【文章內(nèi)容簡介】 _name LIKE 39。_o%39。 NULL 使用 NULL 判斷空值。 SELECT last_name, manager_id FROM employees WHERE manager_id IS NULL。 邏輯運(yùn)算 Operator AND OR NOT Meaning Returns TRUE if both ponent conditions are true Returns TRUE if either ponent condition is true Returns TRUE if the following condition is false AND AND 要求和的關(guān)系為真。 SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary =10000 AND job_id LIKE 39。%MAN%39。 OR OR 要求或關(guān)系為真。 SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary = 10000 OR job_id LIKE 39。%MAN%39。 SELECT last_name, job_id FROM employees WHERE job_id NOT IN (39。IT_PROG39。, 39。ST_CLERK39。, 39。SA_REP39。)。 NOT 優(yōu)先級
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1