목록PRECEDING (2)

pbj0812의 코딩 일기

[SQL] window 함수 frame 절 예제

0. 목표 - window 함수 frame 절을 예제를 통해 학습 1. 실습 1) 테이블 생성 CREATE TABLE sql_test.frame_test ( id char, ordered int, price int ); 2) 데이터 삽입 INSERT INTO sql_test.frame_test(id, ordered, price) VALUES('a', 1, 100); INSERT INTO sql_test.frame_test(id, ordered, price) VALUES('a', 2, 200); INSERT INTO sql_test.frame_test(id, ordered, price) VALUES('a', 3, 300); INSERT INTO sql_test.frame_test(id, ordered, p..
ComputerLanguage_Program/SQL 2022. 3. 15. 01:32
[SQL] PRECEDING 을 통한 증감비교

0. 목표 - PRECEDING 을 통한 증감비교 1. 실습 1) 테이블 생성 CREATE TABLE sql_test.company ( company varchar(12), year int, sale int ); 2) 데이터 삽입 INSERT INTO sql_test.company(company, year, sale) VALUES ('A', 2010, 100); INSERT INTO sql_test.company(company, year, sale) VALUES ('A', 2011, 90); INSERT INTO sql_test.company(company, year, sale) VALUES ('A', 2012, 110); INSERT INTO sql_test.company(company, year, s..
ComputerLanguage_Program/SQL 2021. 3. 15. 01:49
Prev 1 Next