본문 바로가기
문제풀이/HackerRank

Employee Names

by 제밍 2022. 11. 3.

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

Input Format

The Employee table containing employee data for a company is described as follows:

where employee_id is an employee's ID number, name is their name, months is the total number of months they've been working for the company, and salary is their monthly salary.

 

*조건 - 테이블에 있는 이름들을 뽑아내라! (단 , 이름 순으로 정렬할 것)

 

SELECT NAME
FROM EMPLOYEE
ORDER BY NAME ;

 

 

Employee Names | HackerRank

 

Employee Names | HackerRank

Print employee names.

www.hackerrank.com

 

 

'문제풀이 > HackerRank' 카테고리의 다른 글

Employee Salaries  (0) 2022.11.03
Higher Than 75 Marks  (0) 2022.11.03
Weather Observation Station 12  (0) 2022.11.03
Weather Observation Station 11  (0) 2022.11.03
Weather Observation Station 10  (0) 2022.11.03