[SQL] 짝수와 홀수인 조건으로 조회하기

Table of Contents

1. Question
2. Answer
3. Reference

 

Question

Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.
The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

Answer

Question quest us how to query the City names that have an even ID number. So, We use "Condition Filtering" and mod function.

 

MYSQL : 

SELECT DISTINCT CITY
  FROM STATION
 WHERE ID % 2 = 0;

 

ORACLE: 

SELECT DISTINCT CITY
  FROM STATION
 WHERE MOD(ID, 2) = 0 ;

 

 

 

 

Reference

"Arithmetic Operators", MySQL,  https://dev.mysql.com/doc/refman/8.2/en/arithmetic-functions.html

"MOD", Oracle, https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/MOD.html

Revising the Select Query", hackerrank, https://www.hackerrank.com/challenges/revising-the-select-query/