Leetcode力扣 MySQL数据库 1972 同一天的第一个电话和最后一个电话

最新推荐文章于 2024-07-20 20:04:43 发布

ziko-1101

最新推荐文章于 2024-07-20 20:04:43 发布

阅读量287

点赞数

分类专栏： Leetcode MySQL数据库（VIP）题目及解答文章标签：数据库 mysql leetcode

本文链接：https://blog.csdn.net/m0_46458212/article/details/127957727

版权

1972 同一天的第一个电话和最后一个电话

SQL结构

Create table If Not Exists Calls (caller_id int, recipient_id int, call_time datetime);
Truncate table Calls;
insert into Calls (caller_id, recipient_id, call_time) values ('8', '4', '2021-08-24 17:46:07');
insert into Calls (caller_id, recipient_id, call_time) values ('4', '8', '2021-08-24 19:57:13');
insert into Calls (caller_id, recipient_id, call_time) values ('5', '1', '2021-08-11 05:28:44');
insert into Calls (caller_id, recipient_id, call_time) values ('8', '3', '2021-08-17 04:04:15');
insert into Calls (caller_id, recipient_id, call_time) values ('11', '3', '2021-08-17 13:07:00');
insert into Calls (caller_id, recipient_id, call_time) values ('8', '11', '2021-08-17 22:22:22');

表: Calls
+--------------+----------+