Question: Given the data in a a table called Employees, print all pairs of employee names where one earns less than the other. In the first

Given the data in a a table called Employees, print all pairs of employee names where one earns less than the other. In the first column, have the Name of the lower earning employee, and in the second, the Name of the higher earning employee. The output should be ordered first by the ID of the lower earning employee, then by the ID of the higher earning employee, both ascending. Table: EMPLOYEES + + | Field | Type | + + | ID (PK) | Name | Age | Address | Salary | int | char (20) | | int | char (25) | decimal(18,2)| - +
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
