Employee Names

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

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.

Last updated