Revising the Select Query I
SELECT *
FROM CITY
WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA';
SQL
복사
Revising the Select Query II
SELECT NAME
FROM CITY
WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA';
SQL
복사
Select All
SELECT *
FROM CITY;
SQL
복사
Select By ID
SELECT *
FROM CITY
WHERE ID = '1661';
SQL
복사
Japanese Cities' Attributes
SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN';
SQL
복사
Japanese Cities' Names
SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN';
SQL
복사
Weather Observation Station 1
SELECT CITY, STATE
FROM STATION;
SQL
복사
Weather Observation Station 3
SELECT DISTINCT CITY
FROM STATION
WHERE ID % 2 = 0;
SQL
복사
DISTINCT : 중복제거
Weather Observation Station 4
SELECT COUNT(CITY) - COUNT(DISTINCT CITY)
FROM STATION;
SQL
복사
Weather Observation Station 6
SELECT CITY
FROM STATION
WHERE CITY LIKE 'A%'
OR CITY LIKE 'E%'
OR CITY LIKE 'I%'
OR CITY LIKE 'O%'
OR CITY LIKE 'U%';
SQL
복사
SQL 은 대소문자를 구분하지 않는다!