Employee Names

Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order.

Employee Names | HackerRankHackerRank

Sol:

SELECT name FROM Employee ORDER BY name asc;

Explanation:

• SELECT name: This part of the query specifies that we want to retrieve the values from the name column of the Employee table.

• FROM Employee: This specifies the table from which we want to retrieve the data, which is the Employee table.

• ORDER BY name ASC: This part of the query specifies the order in which the results should be sorted. It orders the results in ascending order based on the values in the name column.