191k views
4 votes
Write the sql code that will change the proj_num to 14 for those employees who were hired before january 1, 1994 and whose job code is at least

User Sarartur
by
7.4k points

1 Answer

7 votes
update employees set proj_num = 14 where hire_date <= ‘19940101’
User Billjk
by
7.4k points

No related questions found