Change detection

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Change detection
Date: 2022-12-09 12:55:16
Message-ID: CA+i5JwZ+XmOF6P4Lo=UTVUJBSQN4EyQL-fe7t4XTLPB9bwq9aQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

A record shows all staff member worked in different departments.

For instance, Tom was in sales for several years and got promoted to
management. How to detect the time of this change?

Data

Staff_ID Name Department Year
1 Tom Sales 1990
2 Tom Sales 1991
3 Tom Sales 1991
4 Tom Management 1992
4 Tom Management 1992

Regards,

David

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message 2022-12-09 13:02:10 AW: Change detection
Previous Message Ankit Kumar Pandey 2022-11-27 16:55:05 Re: [QUESTION] Window function with partition by and order by