Question
Write the statement to add the “2222” key and the value “500” to the payroll data¬base opened in Question 12.
Step 1
This will determine the syntax and method for adding a key-value pair to the database. Show more…
Show all steps
Your feedback will help us improve your experience
James Kiss and 66 other educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
UPDATE account SET $\mathrm{DA}=$ basic $^{*} .2$ GROSS $=$ basic $^{*} 1.3$ Where basic $>2000$; (A) The above query displays DA and gross for all those employees whose basic is $\geq 2000$ (B) The above query displays DA and gross for all employees whose basic is less than 2000 (C) The above query displays DA as well as gross for all those employees whose basic is $>2000$ (D) Above all
Databases
ER Model and Relational Model
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD