Register

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

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
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
← Prev Question Next Question →

No related questions found

Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Categories

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Please help me ! All you do is just put it it all in your own words ! Please this is for my reported card!i don't know how to put it in my own words because my English is not that good!
Link Copied!