Employee Names
Data Analyst

빅데이터 관련 자료/[SQL] Basic

Employee Names

carpe08 2021. 8. 12. 00:28
320x100
320x100

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;

320x100
320x100

'빅데이터 관련 자료 > [SQL] Basic' 카테고리의 다른 글

Type of Triangle  (0) 2021.08.13
Employee Salaries  (0) 2021.08.12
Higher Than 75 Marks  (0) 2021.08.11
Weather Observation Station 12  (0) 2021.08.10
Weather Observation Station 11  (0) 2021.08.09