Examine the description of the EMPLOYEES table:
Examine this query:
Which line produces an error?
A. Line 5
B. Line 8
C. Line 7
D. Line 3
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Examine the description of the EMPLOYEES table:
Examine this query:
Which line produces an error?
A. Line 5
B. Line 8
C. Line 7
D. Line 3
|
Download Printable PDF. VALID exam to help you PASS. |
|
D
D, checked
D is the correct answer because we can use the alias name only with ORDER BY clause which will be executed at last. So we cannot use the alias name in other places of the SQL statement