The SELECT statement below will display 'n/a' if an employee has been not assigned to any job yet i.e. JOB_ID ... The function is the SQL equivalence of IF.
確定! 回上一頁