[HackerRank/SQL] Basic Select - Employee Names

Problem. Basic Select - Employee Names

---

Link.

https://www.hackerrank.com/challenges/name-of-employees/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=24-hour-campaign&h_r=next-challenge&h_v=zen 

Employee Names | HackerRank

---

Description.

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

 

Employee 테이블에서 직원의 이름을 알파벳 순으로 정렬해 반환하는 SQL문을 작성하시오.

 

Employee 테이블

---

Key Point. 

ORDER BY, 지정된 컬럼을 기준으로 정렬하는 쿼리문 / 정렬 default 값은 ASC (오름차순) 이다.

---

My Answer. 

SELECT NAME
FROM EMPLOYEE
ORDER BY NAME

---

References.