本篇内容主要讲解“mysql怎么实现的lead和lag函数功能”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“mysql怎么实现的lead和lag函数功能”吧!
MariaDB [test]> select * from t;
+--------------------------------------+---------------------+
| case_id | assigned_date |
+--------------------------------------+---------------------+
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-18 14:08:14 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d51 | 2016-05-18 14:25:22 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-18 14:26:01 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-19 07:19:13 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-19 07:53:09 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d51 | 2016-05-19 08:18:01 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-19 12:12:35 |
+--------------------------------------+---------------------+
7 rows in set (0.00 sec)
MariaDB [test]> SELECT t1.case_id, t1.assigned_date,
-> (SELECT t2.assigned_date
-> FROM t AS t2
-> WHERE t2.case_id = t1.case_id AND
-> t2.assigned_date > t1.assigned_date
-> ORDER BY t2.assigned_date LIMIT 1) AS next_date,
-> (SELECT t2.assigned_date
-> FROM t AS t2
-> WHERE t2.case_id = t1.case_id AND
-> t2.assigned_date < t1.assigned_date
-> ORDER BY t2.assigned_date DESC LIMIT 1) AS prev_date
-> FROM t AS t1;
+--------------------------------------+---------------------+---------------------+---------------------+
| case_id | assigned_date | next_date | prev_date |
+--------------------------------------+---------------------+---------------------+---------------------+
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-18 14:08:14 | 2016-05-18 14:26:01 | NULL |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d51 | 2016-05-18 14:25:22 | 2016-05-19 08:18:01 | NULL |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-18 14:26:01 | 2016-05-19 07:19:13 | 2016-05-18 14:08:14 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-19 07:19:13 | 2016-05-19 07:53:09 | 2016-05-18 14:26:01 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-19 07:53:09 | 2016-05-19 12:12:35 | 2016-05-19 07:19:13 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d51 | 2016-05-19 08:18:01 | NULL | 2016-05-18 14:25:22 |
| 41c19f76-e52e-c4c9-62c2-573c71ec5d50 | 2016-05-19 12:12:35 | NULL | 2016-05-19 07:53:09 |
+--------------------------------------+---------------------+---------------------+---------------------+
7 rows in set (0.01 sec)
到此，相信大家对“mysql怎么实现的lead和lag函数功能”有了更深的了解，不妨来实际操作一番吧！
由 dawei
【声明】：达州站长网内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。