블로그
-
W3School - SQL Practice 5 (Wildcards, In, Between, Alias, Join, Group By, Database)
://www.w3schools.com/sql/exercise.asp? SELECT * FROM Customers WHERE City LIKE '_a%'; Select all records where the first letter of the City
blog.naver.com · 2024.05.06
-
동적쿼리 정적쿼리
컴파일시에 SQL 문장을 확정할 수 없는 경우: where 조건이 달라질때 동적쿼리 지원 구문 if, choose(when,otherwise), trim, foreach * WHERE ( 회사에서 거의 자주봄) WHERE : 조회하려는 데이터들의 조건을 거는 문법
blog.naver.com · 2024.03.07
-
[엑셀보다 쉽고 빠른 SQL] 1일차 (01.02.24)
수업목표 ☑ 데이터베이스와 SQL 이 무엇인지 이해한다 ☑ SELECT, FROM 문을 이용하여 데이터를 조회한다 ☑ WHERE 절을 이용하여 데이터를 필터링한다 SQL 이란? SQL 문이란 : DB 에서 데이터를 조회하기 위한 언어로, SQL 문법을 이용하여 DB에 명령을 내리는 것을 Query 한다고 합니다. # SQL 실습할 수 있는 프로그램 깔기 -
blog.naver.com · 2024.01.02
-
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;
blog.naver.com · 2023.10.16
-
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';
blog.naver.com · 2023.10.16
-
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';
blog.naver.com · 2023.10.16
-
Weather Observation Station 1
Prepare > SQL > Basic Select > Weather Observation Station 1 Query a list of CITY and STATE The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western
blog.naver.com · 2023.10.16
-
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
blog.naver.com · 2023.10.16
-
Revising the Select Query I
Prepare > SQL> Basic Select > Revising the Select Query I Query all columns for all American SELECT 필드명 FROM 테이블명 조건문 --> WHERE 필드명 조건 ;
blog.naver.com · 2023.10.14
-
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
blog.naver.com · 2023.10.14
