order by desc 分页

最新推荐文章于 2023-05-29 00:11:08 发布

lsh_li

最新推荐文章于 2023-05-29 00:11:08 发布

阅读量322

点赞数

分类专栏：数据库文章标签： SQL

数据库专栏收录该内容

9 篇文章

订阅专栏


t_user表：
+---------+-----------+----------+-------------+-------+---------------------+
| user_id | user_name | password | contact_tel | email | create_date         |
+---------+-----------+----------+-------------+-------+---------------------+
| a1234   | qwert     | qwerty   | NULL        | NULL  | 2009-06-02 21:31:28 |
| asdf    | asdf      | asdfgh   | NULL        | NULL  | 2009-06-02 21:31:11 |
| b1234   | zxcv      | asdfgh   | NULL        | NULL  | 2009-06-02 21:31:41 |
| c1234   | rtuur     | asdfgh   | NULL        | NULL  | 2009-06-02 21:31:56 |
| d1234   | fghj      | asdfgh   | NULL        | NULL  | 2009-06-02 21:32:20 |
| e1234   | sdfg      | asdfgh   | NULL        | NULL  | 2009-06-02 21:32:37 |
| f1234   | egfujhry  | wertyu   | NULL        | NULL  | 2009-06-02 21:32:49 |
| g1234   | qwertt    | asdfgh   | NULL        | NULL  | 2009-06-02 21:32:57 |
| root    | 管理员    | root123  | NULL        | NULL  | NULL                |
+---------+-----------+----------+-------------+-------+---------------------+


select * from t_user order by create_date desc limit 1, 3;
结果：
+---------+-----------+----------+-------------+-------+---------------------+
| user_id | user_name | password | contact_tel | email | create_date         |
+---------+-----------+----------+-------------+-------+---------------------+
| f1234   | egfujhry  | wertyu   | NULL        | NULL  | 2009-06-02 21:32:49 |
| e1234   | sdfg      | asdfgh   | NULL        | NULL  | 2009-06-02 21:32:37 |
| d1234   | fghj      | asdfgh   | NULL        | NULL  | 2009-06-02 21:32:20 |
+---------+-----------+----------+-------------+-------+---------------------+