SQL Interview Questions and Answers
Question: What is the value of comm and sal after executing the following query if the initial value of 'sal' is 10000 UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;?Answer: sal = 11000, comm = 1000. |
Save For Revision
Bookmark this item, mark it difficult, or place it in a revision set.
Log in to save bookmarks, difficult questions, and revision sets.
Is it helpful? Yes No
Most helpful rated by users: