- 首先，資料庫是一個普通的單行，但我們必須在創建時查詢以將其獲取到分配部分：
- 任務是以這種格式安排提供日期的任務，以創建作業流程的時間表
- 動機是以這種格式排列它們
我完全不知道，但已經嘗試過與 group by 一起做的事情，并且對任何答案都持開放態度
抱歉，新來的請幫忙謝謝！`
CREATE DATABASE project ;
CREATE TABLE project_phases(
project_id int,
phase varchar(200),
start_date date
);
INSERT INTO project_phases (project_id,phase,start_date)
VALUES (1, 'design', '2021-01-01');
INSERT INTO project_phases (project_id,phase,start_date)
VALUES (1, 'development', '2021-01-02');
INSERT INTO project_phases (project_id,phase,start_date)
VALUES (1, 'deployment', '2021-01-03');`
uj5u.com熱心網友回復：
似乎視窗函式lead() over()很適合這里
Select project_id
,from_phase = phase
,to_phase = lead(phase,1) over (partition by project_id order by start_date)
,start_date
,end_date = lead(start_date,1) over (partition by project_id order by start_date)
from project_phases
結果
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/358338.html
標籤：sql-server 数据库 数据库管理系统