Microsoft
98-364 · Question #116
Roger is the HR Manager of Neon Inc. He wants to generate a report of all the employees working in Department ID 30 from the Emp table on the following attributes: - Fname - Lname - Salary All the…
The correct answer is D. SELECT Fname, Lname, Salary FROM Emp WHERE DeptId=30 ORDER BY Lname. See the full explanation below for the reasoning.
Question
Roger is the HR Manager of Neon Inc. He wants to generate a report of all the employees working in Department ID 30 from the Emp table on the following attributes:
- Fname
- Lname
- Salary
All the records should be sorted in ascending order of the Lname attribute. Which of the following queries will he use to get the required output?
Options
- ASELECT Fname Lname Salary FROM Emp WHERE DeptId=30 ORDER BY Lname
- BSELECT Fname, Lname, Salary FROM Emp ORDER BY Lname WHERE DeptId=30
- CSELECT Fname Lname Salary FROM Emp ORDER BY Lname WHERE DeptId=30
- DSELECT Fname, Lname, Salary FROM Emp WHERE DeptId=30 ORDER BY Lname
How the community answered
(40 responses)- A3% (1)
- B15% (6)
- C8% (3)
- D75% (30)
Community Discussion
No community discussion yet for this question.