SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE t ( my_date varchar(100), client varchar(100), namber varchar(100) ); insert into t values ('2023-04-03 15:00:00', 'Vova', '79999999'); insert into t values ('2023-04-03 15:00:10', 'Vova', '71999998'); insert into t values ('2023-04-03 15:00:20', 'Vova', '722999997'); insert into t values ('2023-04-03 15:00:30', 'Vova', '725154511'); insert into t values ('2023-04-03 15:00:05', 'Ivan', '715615651'); insert into t values ('2023-04-03 15:00:10', 'Ivan', '789452143'); insert into t values ('2023-04-03 15:00:15', 'Ivan', '7852132158'); insert into t values ('2023-04-03 15:00:25', 'Ivan2', '789456132'); insert into t values ('2023-04-04 15:01:15', 'Ivan2', '78945561'); insert into t values ('2023-04-04 15:01:30', 'Ivan2', '78945613'); insert into t values ('2023-04-04 15:01:45', 'Ivan2', '789451321'); insert into t values ('2023-04-04 15:02:00', 'Ivan2', '77748964'); insert into t values ('2023-04-04 15:02:00', 'Iva', '77748964'); Select client, Min(namber) keep (DENSE_RANK FIRST ORDER BY my_date asc) fst, Max(namber) keep (DENSE_RANK Last order by my_date asc) lst from t Group by client Having count(*) > 1 and Min(namber) keep (DENSE_RANK FIRST ORDER BY my_date asc) <> Max(namber) keep (DENSE_RANK Last order by my_date asc)