Try Another
The new company fiscal year is approaching and the Accounting department's budget director is compiling some salary statistics.
The budget director needs a list of employee IDs, job IDs, and salaries where the salary is greater than $100,000. The POSITION table contains this information.
The result looks like this:
EMP_ID JOB_ID SALARY_AMOUNT ------ ------ ------------- 2894 6021 111593.00 3222 6004 110448.00 1234 8001 117832.68 1003 9001 146432.00 4 rows processed
If your results do not match what you see above, check Review Answers for Chapter 4 for the correct SQL syntax. Remember that result tables may be shortened in this guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|