You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
16 lines
383 B
16 lines
383 B
USE Study
|
|
GO
|
|
|
|
-- 행순서 함수
|
|
|
|
-- FISRT_VALUE: 첫번째 튜플만
|
|
SELECT DISTINCT DNO, FIRST_VALUE(SALARY) OVER (PARTITION BY DNO ORDER BY SALARY DESC) AS HIGH_SALARY
|
|
FROM EMPLOYEE
|
|
|
|
-- LAG/LEAD: 정렬 기준 선행/후행 값 출력
|
|
SELECT
|
|
DISTINCT ENAME,
|
|
SALARY,
|
|
LAG(SALARY, 1) OVER(ORDER BY SALARY DESC) AS LAG_SALARY,
|
|
LEAD(SALARY, 1) OVER(ORDER BY SALARY DESC) AS LEAD_SALARY
|
|
FROM EMPLOYEE |