#히민's 메모장

문제 Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 different city names: 'New York..

문제 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: 풀이 SELECT DISTINCT city FROM STATION WHERE MOD(ID, 2)=0 - MOD 함수란? 두개의 숫자를 나눌때 나머지를 구하는 함수 SELECT MOD(10, 2) FROM TABLE - 중복 제거 SELECT DISTINCT