IBM
C2090-610 · Question #137
Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of…
The correct answer is B. SELECT empno, hiredate, salary. See the full explanation below for the reasoning.
Question
Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?
Options
- ASELECT empno, hiredate, salary
- BSELECT empno, hiredate, salary
- CSELECT empno, hiredate, salary
- DSELECT empno, hiredate, salary
How the community answered
(25 responses)- A4% (1)
- B76% (19)
- C8% (2)
- D12% (3)
Community Discussion
No community discussion yet for this question.