블로그
- Select All Prepare > SQL > Basic Select > Select All Query all columns (attributes) for every row in the The CITY table is described as follows: SELECT * FROM CITY
- Select By ID Prepare > SQL > Basic Select > Select By ID Query all columns for a city in CITY with the ID The CITY table is described as follows: SELECT * FROM city WHERE ID = 1661;
- Japanese Cities' Attributes Prepare > SQL > Basic Select > Japanese Cities' Attributes Query all attributes of every Japanese The CITY table is described as follows: SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';
- Japanese Cities' Names Prepare > SQL > Basic Select > Japanese Cities' Names Query the names of all the Japanese cities The CITY table is described as follows: SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';
- Revising the Select Query II Prepare > SQL > Basic Select > Revising the Select Query II Query the NAME field for all American The CITY table is described as follows: SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION
- Revising the Select Query I Prepare > SQL> Basic Select > Revising the Select Query I Query all columns for all American SELECT 필드명 FROM 테이블명 조건문 --> WHERE 필드명 조건 ;
- Weather Observation Station 1 Prepare > SQL > Basic Select > Weather Observation Station 1 Query a list of CITY and STATE SELECT CITY, STATE FROM STATION
- Weather Observation Station 3 Prepare > SQL > Basic Select > Weather Observation Station 3 Query a list of CITY names from SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0; 짝수(even ID) = MOD(column, 2) = 0
- Weather Observation Station 4 Prepare > SQL > Basic Select > Weather Observation Station 4 Find the difference between the
- Weather Observation Station 5 Prepare > SQL > Basic Select > Weather Observation Station 5 Query the two cities in STATION