Assuming you are using SQL, here is a step-by-step guide on how to write the query:

1. First, you need to identify the table that contains the employee names and salaries. Let's assume this table is called `employees` and the columns for employee name and salary are `ename` and `salary` respectively.

2. To find the employee(s) with the highest salary, you need to use the `MAX()` function. However, since you also want to display the employee names, you can't simply use `SELECT MAX(salary) FROM employees;` because this would only return the highest salary, not the name(s) of the employee(s) who earn this salary.

3. Instead, you need to use a subquery to first find the highest salary, and then find the employee(s) who earn this salary. Here's how you can do this:

```sql
SELECT ename
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees)
ORDER BY ename ASC;
```

Here's what this query does:

- The subquery `(SELECT MAX(salary) FROM employees)` finds the highest salary.
- The main query then finds the employee(s) who earn this salary.
- `ORDER BY ename ASC` sorts the results in ascending order by employee name.

This will give you the name(s) of the employee(s) who earn the highest salary, sorted in ascending order by name.

Question

Assuming you are using SQL, here is a step-by-step guide on how to write the query:

1. First, you need to identify the table that contains the employee names and salaries. Let's assume this table is called `employees` and the columns for employee name and salary are `ename` and `salary` respectively.

2. To find the employee(s) with the highest salary, you need to use the `MAX()` function. However, since you also want to display the employee names, you can't simply use `SELECT MAX(salary) FROM employees;` because this would only return the highest salary, not the name(s) of the employee(s) who earn this salary.

3. Instead, you need to use a subquery to first find the highest salary, and then find the employee(s) who earn this salary. Here's how you can do this:

```sql
SELECT ename
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees)
ORDER BY ename ASC;
```

Here's what this query does:

- The subquery `(SELECT MAX(salary) FROM employees)` finds the highest salary.
- The main query then finds the employee(s) who earn this salary.
- `ORDER BY ename ASC` sorts the results in ascending order by employee name.

This will give you the name(s) of the employee(s) who earn the highest salary, sorted in ascending order by name.

Knowee AI · Accepted Answer

Assuming you are using SQL, here is a step-by-step guide on how to write the query:

1. First, you need to identify the table that contains the employee names and salaries. Let's assume this table is called `employees` and the columns for employee name and salary are `ename` and `salary` respectively.

2. To find the employee(s) with the highest salary, you need to use the `MAX()` function. However, since you also want to display the employee names, you can't simply use `SELECT MAX(salary) FROM employees;` because this would only return the highest salary, not the name(s) of the employee(s) who earn this salary.

3. Instead, you need to use a subquery to first find the highest salary, and then find the employee(s) who earn this salary. Here's how you can do this:

```sql
SELECT ename
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees)
ORDER BY ename ASC;
```

Here's what this query does:

- The subquery `(SELECT MAX(salary) FROM employees)` finds the highest salary.
- The main query then finds the employee(s) who earn this salary.
- `ORDER BY ename ASC` sorts the results in ascending order by employee name.

This will give you the name(s) of the employee(s) who earn the highest salary, sorted in ascending order by name.

Write a query to display the ename of employee who draw the highest salary. In case of multiple records, display the records sorted in ascending order based on ename.

Question

Solution

Similar Questions

Upgrade your grade with Knowee