SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Gr ( user_id INT, user_inn INT, event_date DATE ); INSERT INTO Gr (user_id, user_inn, event_date) VALUES(100, 987, '2022-06-12'), (101, 988, '2022-06-02'), (122, 789, '2022-06-06'), (103, 895, '2022-06-28'), (104, 999, '2022-06-30'), (107, 877, '2022-06-02'), (122, 789, '2022-06-30'), (141, 932, '2022-06-18'), (122, 547, '2022-06-25'), (107, 877, '2022-06-19'), (107, 687, '2022-06-02'), (107, 877, '2022-07-30'), (141, 932, '2022-07-18'), (122, 789, '2022-07-05'), (122, 766, '2022-07-05'), (122, 722, '2022-07-15'), (107, 554, '2022-06-10'), (107, 555, '2022-06-17'), (107, 554, '2022-06-10'), (141, 102, '2022-06-03'), (141, 922, '2022-06-22'); select * from ( select user_id, extract(year_month from event_date) as ym, user_inn, user_inn != lag(user_inn, 1, user_inn) over ( partition by user_id, extract(year_month from event_date) order by event_date ) as is_changed from Gr ) tmp
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear